Michelledryr
New Member
- Joined
- Sep 27, 2017
- Messages
- 16
Hi Guys,
Hope you are able to assist me please, I am very new to the VBA codes
My workbook has 2 worksheets. Sheet 1 (Form) Sheet 2 (Result).
Result sheet pulls all the info from the Form sheet.
I would like a command button on the Form sheet which will print the Result sheet to PDF and save it on the desktop with the name from cells out of the result sheet.
Thus I require the command button to do the following please:
1. Print Result sheet to PDF
2. Save PDF with name from Result sheet B14 +G21+ B12
3. Save PDF in Folder on Desktop Named Quotes
Thanking you in advance for your kind assistance
Hope you are able to assist me please, I am very new to the VBA codes
My workbook has 2 worksheets. Sheet 1 (Form) Sheet 2 (Result).
Result sheet pulls all the info from the Form sheet.
I would like a command button on the Form sheet which will print the Result sheet to PDF and save it on the desktop with the name from cells out of the result sheet.
Thus I require the command button to do the following please:
1. Print Result sheet to PDF
2. Save PDF with name from Result sheet B14 +G21+ B12
3. Save PDF in Folder on Desktop Named Quotes
Thanking you in advance for your kind assistance