Macro to create 2 separate PDF files of 2 sheets - saved in same location

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

Hi Matt,

I created a similar "tool" recently for Quotes/Orders.
My concern with your request is that if the Quote(s) and the PDF(s) are saved using exactly the same reference it will "replace" the previous one that was saved.
You will have to include a Customer Name and Quote No. in the reference so that each "save" is different.

Regards

peterrc

Thank you Bakerman2, very helpful. Could you please let me know what needs to change to prevent the PDF's opening? Also, the excel file saves in a different format, is that correct?

Many thanks

Thank you Kev