Hi,
I have a workbook that has over 100 worksheets (one worksheet exports to 3 pages) I need to export each worksheet to its own PDF file. I have tried extracting from Adobe, but I cannot read the sheets and since each worksheet exports 3 pages I have to combine the pages into one PDF file. I tried a VBA, but I keep getting errors and everything I try doesn’t fix the problem. Can someone help me with exporting, if a VBA is used what Reference under Tools do I need to make sure is selected, I have that problem with Power Point and I have to select it whenever I run the VBA to export to Power Point? Any help you can provide is appreciated.
I have a workbook that has over 100 worksheets (one worksheet exports to 3 pages) I need to export each worksheet to its own PDF file. I have tried extracting from Adobe, but I cannot read the sheets and since each worksheet exports 3 pages I have to combine the pages into one PDF file. I tried a VBA, but I keep getting errors and everything I try doesn’t fix the problem. Can someone help me with exporting, if a VBA is used what Reference under Tools do I need to make sure is selected, I have that problem with Power Point and I have to select it whenever I run the VBA to export to Power Point? Any help you can provide is appreciated.