Hi Everyone
I am totally new to using Macros, so learning and trying to do, so please excuse my ignorance.
I have a spreadsheet with data pertaining to different functional units/groups(almost 200 units). My goal is to generate a pdf report for each section of data (for each unit) and prompt the user to name the pdf.
So far I have been able to automatically generate page breaks at the end of each section of data and create one single pdf with 200 pages.
I want to generate a new pdf when a page break is encountered, while prompting for filename. (using a macro)
I know it may not be fair to ask for solution, but a solution or direction to get the solution would be of immense help.
I have Acrobat standard installed and I use excel 2007.
Appreciate any inputs, thoughts, help.
Thanks a ton in advance.
Sita
I am totally new to using Macros, so learning and trying to do, so please excuse my ignorance.
I have a spreadsheet with data pertaining to different functional units/groups(almost 200 units). My goal is to generate a pdf report for each section of data (for each unit) and prompt the user to name the pdf.
So far I have been able to automatically generate page breaks at the end of each section of data and create one single pdf with 200 pages.
I want to generate a new pdf when a page break is encountered, while prompting for filename. (using a macro)
I know it may not be fair to ask for solution, but a solution or direction to get the solution would be of immense help.
I have Acrobat standard installed and I use excel 2007.
Appreciate any inputs, thoughts, help.
Thanks a ton in advance.
Sita
