Macro to work on any computer

[Oeysbrei]

Hi,

I`m about to create a program to generate invoices, but need some help to modify a code to make it work in any computer.

This is the code i`m using now:

This code as I can read it, will only be able to save the PDF in my computer.
I hope somebody have a god idea that will help me solve this problem.

Best regards
喕stein Breivik

[6StringJazzer]

The expression

Application.DefaultFilePath

will return the default file path on a Windows computer. On your machine it's probably

"C:\Users\喕stein Breivik\Documents"

Your current code has a path that may not exist on another computer. Where do you want the file to be saved when it's someone else's computer? Do you want to create a folder if it doesn't already exist?

I do not know what the equivalent is on a Mac--do you also need to consider Macs?

[Norie]

Kind of a duplicate thread, didn't get back to the original as I'm afraid the OP didn't make it clear exactly what was needed to have the code work on 'any' computer.

[Oeysbrei]

Thanks for youre reply 6stringjazzer

I dont need to consider Macs. If you could help me to make the file be saved in the download folder would be great. Than the user will to be able to save it somewhere els manually later.

Regards
喕stein

[6StringJazzer]

I get this:

Please Login or Register  to view this content.

[AliGW]

Unfortunately this is a duplicate thread and as such will now be closed. You may continue in your other thread: https://www.excelforum.com/excel-pro...-computer.html

Thread closed.