Saving an Excel file in a designated folder

Hi All,

I need help with the correct code to enable me to save an Excel file in a specific/designated folder on my computer.

I have an invoice program which, after being generated, prints and saves a copy as PDF in the same folder where the invoice program resides. The printing and saving currently works OK, and the code that does the saving is as follows:

Please Login or Register  to view this content.

The above code saves the PDF copy in the same folder as the Invoice program. However, I would like the PDF copy to be saved in a designated folder named 'Copy Invoices' on my desktop and not in the same folder as the main Invoice program, which, currently is the situation. Here is the Path to the designated folder in which I want the PDF copy to be stored:

"ChDir C:\Documents and Settings\Me\Desktop\Copy Invoices"

I therefore need help, please, to incorporate this path into the above code so that the PDF copy will be saved in the 'Copy Invoices' folder on my desktop.

Thanks for your help.

Buddy

Change this:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.


If you only use the location once, it doesn't make much difference. If you use it several times, it would make sense to use John's approach. The big advantage of defining and using a variable is that it makes it easier to locate and change, should you want to. I was just addressing the immediate problem with the information provided.