I have a print all layouts function that allows the user to pick the pagesetup and print all the layouts using this pagesetup.
However adobe pdf's use a default name of the layout name +(1) eg "Layout1(1). I want the file to be called the same as the sheet name which is longer than the abbreviated sheetname I use for the layout name. I cant seem to find a way. If I temporarily change the layout name from say CA-1.1 to 5555-CA-1.1, I still end up with the file being called 5555-CA-1.1(1).
The time lag is so long I cant figure out how to simply change the files name afterward either.
