E_DPSG
Board Regular
- Joined
- Jul 17, 2008
- Messages
- 82
Good Afternoon -
I am trying to get multiple sheets from one excel file and a single sheet from a second excel file to print into a single PDF file. I have tried to copy the single sheet into the main workbook, but, thanks to the non-standardized formatting between the single 'cover sheet' pages, I am running into lots of issues.
As it stands, I cannot use the distiller process Adobe offers to handle this as I am in a citrix environment with very few permissions. I do have the full version of acrobat installed and can get the multiple pages to print to a single pdf file. It is just the insert of the secondary file!
I have thought about deleting the rows/columns in the destination sheet, but it ends up with the inserted images remaining. I even went with deleting the entire sheet, inserting the new sheet, processing the copy over, and - I lose my print area settings.
Maybe some help on the setting print areas thru VBA would be a better way to do this.
Oh: Excel 2003 (really cutting edge over here) and Acrobat 7.0.
Any thoughts???
I am trying to get multiple sheets from one excel file and a single sheet from a second excel file to print into a single PDF file. I have tried to copy the single sheet into the main workbook, but, thanks to the non-standardized formatting between the single 'cover sheet' pages, I am running into lots of issues.
As it stands, I cannot use the distiller process Adobe offers to handle this as I am in a citrix environment with very few permissions. I do have the full version of acrobat installed and can get the multiple pages to print to a single pdf file. It is just the insert of the secondary file!
I have thought about deleting the rows/columns in the destination sheet, but it ends up with the inserted images remaining. I even went with deleting the entire sheet, inserting the new sheet, processing the copy over, and - I lose my print area settings.
Maybe some help on the setting print areas thru VBA would be a better way to do this.
Oh: Excel 2003 (really cutting edge over here) and Acrobat 7.0.
Any thoughts???
