ExportAsFixedFormat with multiple worksheets problem

I'm writing VBA in MS Access to control an Excel workbook. The final stage of the process is printing two of the worksheets in the workbook to PDF. I'm having a problem combining the two worksheets and printing them. I keep getting error 438 "Object doesn't support this property or method). Printing to PDF one of the worksheets works OK but I should be able to combine two or more. Here's the code:

Please Login or Register  to view this content.

The commented out line is the one that works but I need the first line, with the Array statement, to work.

Thank you for your help.

Maybe use the ExportAsFixedFormat method, but for a workbook.
Idea of operation:
1. discover all sheets, but remember the visibility state of each sheet
2. hide all the unnecessary ones
3. export to PDF
4. discover all sheets
5. restore the original visibility of the sheets.

If export to PDF is the only action performed with the file, the macro will limit itself to the first three items in the above list, without remembering the visibility state. After the export, close the file without saving.

Please Login or Register  to view this content.

Artik

Thank you very much for replying.

I tried something that shouldn't have worked but did:

Please Login or Register  to view this content.

So far, it works even though the SELECT statement shouldn't work.

Thanks again for replying. I will keep your code in case my solution fails at some point.