New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Need help in macro or vba to generate button

Macros, VBA, Excel Automation, etc.

Need help in macro or vba to generate button

Postby tomsangels » Thu Apr 07, 2016 11:48 am

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.
  • 0

You do not have the required permissions to view the files attached to this post.
tomsangels
Rookie
 
Posts: 3
Joined: Mar 24, 2015
Reputation: 0
Excel Version: 2010

Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 18 guests