Define Array from Listbox to enable ExportAsFixedFormat

Hey folks

This is my first post so hello to everyone.

I have been tearing my hair out about this one - and i dont have much hair!

I want to create a macro that will ...

1) open a Userform with a listbox listing every sheet in the workbook
2) from that listbox select the sheets i want to export
3) click a button and automatically EXPORTASFIXEDFORMAT (in this case PDF) for the selected sheets

I am planning on putting this in the 'PERSONAL' spreadsheet to enable this to work in ANY workbook, therefore the sheet names will constantly change.

also the export has to combine the sheets and not do it individually.

Please tell me if im asking too much from Excel!!

TVM

Hello,

Here is the code I use

Please Login or Register  to view this content.