Hi all
Im trying to save the PDF in the directory as the excel file, each month will have a separate sheet and will be in a separate directory. Instead of selecting a fixed directory, can I save the PDF in the same location as the excel file itself?
Cheers
Ben
Im trying to save the PDF in the directory as the excel file, each month will have a separate sheet and will be in a separate directory. Instead of selecting a fixed directory, can I save the PDF in the same location as the excel file itself?
Cheers
Ben