Excel workbook as Single PDF File

[Chuck6475]

A few years ago Domski contributed some code to under the title - Save Excel Sheet as PDF file (Solved) It works great. Thanks Domski.

I'm trying to make a slideshow that can change dynamically. Acrobat in full screen will run the slideshow and by writing over the source pdf with each update it appears dynamic.

The problem with Acrobat is the pdf has to be a multipage pdf for this to work without intervention.

Problem: How to make a single multipage pdf of selective worksheets.

 

[shg]

Via the UI, press Create PDF from the Acrobat tab and you'll be prompted to select the sheets of interest.

Via VBA, select the sheets of interest and do ActiveSheet.ExportAsFixedFormat.

 

[Chuck6475]

Via the UI, press Create PDF from the Acrobat tab and you'll be prompted to select the sheets of interest.

Via VBA, select the sheets of interest and do ActiveSheet.ExportAsFixedFormat.

using 2003 and yes I can under the UI go to "Adobe PDF" and it will allow me to select the pages I want to put into a single document.

Mirroring that in VBA is currently beyond me. I haven't been able to find ".exportasfixedformat" anywhere. Sorry for having to ask for a little more data but......

 

[shg]

ExportAsFixedFormat was added in Excel 2007.

It would be convenient if you would post the version of Excel you're using in your questions.

 

[Chuck6475]

ExportAsFixedFormat was added in Excel 2007.

It would be convenient if you would post the version of Excel you're using in your questions.

Sorry I typically have. Think I'll look into upgrading.

 

[Chuck6475]

ExportAsFixedFormat was added in Excel 2007.

It would be convenient if you would post the version of Excel you're using in your questions.

Okay, I got 2010 and tried ExportasFixedFormat. It work just like the routine I had from Domski in 2003 for single worksheet. As you pointed out in your first reply, using the Adobe tab in manual mode you can select the worksheets you want to put into a single pdf. I don't seem to be able to figure out how to do the same think with Export..... . I can get individual sheets but not all of them together. What am I missing?