Hi,
I'm using Ken's code taken from the following link in an attempt to create a single PDF document made up of multiple worksheets in the same workbook.
http://www.excelguru.ca/node/22#MultiSingle
The macro seems to run OK but I can't seem to find where the PDF is saved to. I've done multiple searches across all drives to no avail. Ideally I would like to to save to the same directory as the Excel file that I am converting with the same filename as the Excel file.
It would be really appreciated if someone could assist. Apologies if this is simple thing to do, I'm a bit of a VBA novice!
Thanks in advance.
I'm using Ken's code taken from the following link in an attempt to create a single PDF document made up of multiple worksheets in the same workbook.
http://www.excelguru.ca/node/22#MultiSingle
The macro seems to run OK but I can't seem to find where the PDF is saved to. I've done multiple searches across all drives to no avail. Ideally I would like to to save to the same directory as the Excel file that I am converting with the same filename as the Excel file.
It would be really appreciated if someone could assist. Apologies if this is simple thing to do, I'm a bit of a VBA novice!
Thanks in advance.