banderson7563
New Member
- Joined
- Feb 2, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
I currently use a spreadsheet to create all my quotes for my customers. Overall I have it pretty clean and quick, but one thing that can save me time is being able to automate creating a folder, saving the file, and printing a PDF to email to the customer. All formats are the same for the quote, so the names are being pulled in from the same spot. My goal is for this macro to:
1. create a new folder in C:\Users\myname\My Files\Quotes - the name for the this file would pull from two spots on the sheet and be "B3 - A19". an example of what this would look like would be "ABC Company - XYZ System"
2. Save the workbook in this newly created folder as "Quote - B3" so in the example above it would be "Quote - ABC Company"
3. Create a PDF saved in the newly created folder with the same name as the workbook - "Quote - B3" so in the example it would be "Quote - ABC Company"
Any help or ideas would be great! Thanks in advance
1. create a new folder in C:\Users\myname\My Files\Quotes - the name for the this file would pull from two spots on the sheet and be "B3 - A19". an example of what this would look like would be "ABC Company - XYZ System"
2. Save the workbook in this newly created folder as "Quote - B3" so in the example above it would be "Quote - ABC Company"
3. Create a PDF saved in the newly created folder with the same name as the workbook - "Quote - B3" so in the example it would be "Quote - ABC Company"
Any help or ideas would be great! Thanks in advance