Hi,
**edit
If the dropbox folder part can't be done, please advise or replace it on c:\temp\
**original post
i have an invoice template which i store it on my dropbox folder at desktop, in which have 3 corresponding button.
the file is going to be stored in my dropbox folder on desktop.
the first button -> is to generate the next invoice number. this has been accomplish.
however for the second button -> Save to PDF
i tried all the codes available but still fail and have remove it.
by pressing the 2nd Button, i want it to save as pdf (filename as the invoice number) and save it to -> %USERPROFILE%\Dropbox\Sales Invoice\Saved Data
Another note: will the save location works? as i have 4 people working on it and save it to their dropbox folder because i shared them these file with read/write permission
The third button.
this close the excel file and overwrite the existing file and save it as xlsm (Dropbox\Sales Invoice) folder
i appreciate the help very much. and any other concern or clarification needed. please let me know.
Cheers.