Need Macro that will save worksheet as PDF using a cell value in simultaneous locations

[Aaron Garrett]

Hello All,

I am building an invoice system in excel 2007 that will save as pdf in two separate locations using cell value as names. The first location will be named after cell "D7" which is the last name of a client followed by "B7" which is the first name. The location is C:\Desktop\InvoicingSystem\CustomerBasedReceipts\.

The second is based on the cell "H5" which is the invoice number. The path is the same except it ends with \Invoices\ (instead of CustomerBasedReceipts).

I am VERY new to VBA and it absolutely lost with this. Not even exactly sure that the pathway is 100% correct, although I feel fairly certain that it is.

All help will be very appreciated! Thank you!!

 

[Nebu]

Hi:

Refer the following link.

http://stackoverflow.com/questions/26350314/vba-save-as-pdf-with-filename-as-cell-value

Thanks

 

[Aaron Garrett]

I will check that out. Thanks!