Automatically save as pdf but include location

J

jono1966

I have a workbook with 4 worksheets the first is called “input”which
use to enter information which goes to the other worksheets which ar
called body, curtains and doors

I am stuck on the following; after inputting the information I want t
save as pdf’s in various locations.

Is it possible to have 4 buttons on the input sheet which automaticall
:
Button 1 - Save “body” worksheet as a pdf to a specified folder exampl
G: Archive\Body using info from a set cell on the worksheet

As above for other sheets

Thanks in advance for any help and advic
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save as PDF 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Save mulit-page two-sided document as a PDF 1
Button to Save File as PDF 6
email from Excel Question for Ron de Bruin (or other really smart people) 0
Automation of scanned file storage based on content 0
Problem when publishing to PDF 0
Problems executing commands on one file from another 11

Top