Exporting a multi-sheet Excel workbook as PDF in VBA

Question

I'm using Excel 2007 to build a complex multi-tab (sheet) workbook. I'd like to save this out as PDF from within VBA. I'm trying to use ExportAsFixedFormat.

Sure enough, this call correctly exports a PDF, with the right name in the right place. However, it consists only of the currently visible tab.

I found a thread about this in Excel 2010 (which I assume is similar/same) which placed all of the sheets in an array and then selected them...

Sheet(Array("One", "Two")).Select

However, this returns an error on my machine, that the Select failed.

I'm sure this is something fairly simple, any pointers?

See this link msdn.microsoft.com/en-us/library/ee834871%28office.11%29.aspx — Siddharth Rout
– Siddharth Rout, Commented Oct 25, 2012 at 19:34
Record a macro - select multiple tabs manually (click on the tabs holding the CTRL key) - stop recording and check the code. — assylias
– assylias, Commented Oct 25, 2012 at 19:35

Maury Markowitz · Accepted Answer · 2012-10-25 19:33:14Z

4

sigh It was something simple.

If you Export ActiveWorkbook instead of ActiveSheet... then you get all the sheets without any Array or Select.

answered Oct 25, 2012 at 19:33

Maury Markowitz

9,34412 gold badges55 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exporting a multi-sheet Excel workbook as PDF in VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related