Hi
I have a quote tool that I need to create a macro that when the users push the button "complete" it will automatically complete the following;
Save the excel file as "Sheet1!A1 Sheet1!A2 " in location C:\Users\Matt\Desktop\Matts quotes
Then create PDF copys of;
sheet name = systemdesign
save as =Sheet1!A1 Sheet1!A2/systemdesign
File type = PDF
File location = C:\Users\Matt\Desktop\Matts quotes
sheet name = kitlist
save as =Sheet1!A1 Sheet1!A2/kitlist
File type = PDF
File location = C:\Users\Matt\Desktop\Matts quotes
Then open both pdfs on completion.
Many thanks for your help
Matt
Bookmarks