VBA Help with saving a worksheet as a pdf

[gjwilson1216]

Hi there,

I got the below code and it works great. I would just like to do some tweaking and need some help. I want to have the code save the active worksheet as a temp pdf, instead of bringing up the save dialog box. Here is the system I am working on. A form pops up which gathers information and puts it into a purchase order form which is a worksheet. The employee then clicks on a button to save the worksheet as a pdf into a directory determined by what information is gathered. A button to send a copy of the CSV worksheet to the accounting department, and finally I want a button that will have the worksheet sent off as a pdf to a particular vendor. This code works great, but I want to take the file naming away from employees so the file is saved in a special format. So for the pdf to be emailed off to the vendor, the file is already saved where it needs to be saved, in essence I just need something that coverts the worksheet to a pdf with a name that could stay the same such as purchase order and then the pdf could be erased after it was sent.

I don't know if I am making this overly difficult, but its the system I came up with.

[TMS]

Just dump the GetSaveAsFileName dialogue and build your own file name using the paths, file names and extensions you want.


Regards, TMS

[gjwilson1216]

Appologies, I have no idea how to do that. I am an accountant by trade with very minimal VBA code expirience trying to satisfy a clients need. My idea was to fill in the Fixedfilepathname = "purchase order" and then attempted to get rid of the rest of the sequence and got an error on the end if line.

[slx]

You need to understand what it is doing before you can make changes.
This piece checks to see if FixedFilePathName has an answer.

Please Login or Register  to view this content.

="" means no answer.

All you have to do is give FixedFilePathName an answer before it gets to the question.