I have an excel template that I use for creating quotes.
I would like an ActiveX button in the quote template that creates an excel macro-enabled spreadsheet and a PDF.
Saves ENTIRE excel workbook WITH macros to:
/Users/BarryPendley/Google Drive/1-insulation/quotes
Saves sheet labeled INVOICE as a PDF to:
/Users/BarryPendley/Google Drive/1-insulation/QuotesPDFs
Filename to include:
1. Quote number: located in cell E3 on “Invoice” sheet
2. Customer Name: Located in cell B2 on “QuoteWorkup” sheet
Example of filenames would be:
[login to view URL]
[login to view URL]