Excel Convert to PDF and Save in a Folder

Hello,

I have attached a workbook where I created a command button on the first sheet called "CREATE PDF". I'm looking for a code that will convert this sheet into a pdf and save
in a folder on our network drive -------> 'G:\Finance\Corporate Accounting\SHIRLEY\A. Financial Planning Fee Payment Processing'

If possible could the naming convention for the pdf be the current date yyyymmdd + the content of J6 on the worksheet. Example 20170818Invoice#1

Any help on this would be much appreciated.

(don't know if it's also possible that once saved would take you to the pdf in the folder or open the pdf on the screen, just wondering but the top portion would be amazing if it can be done)

Thank you very much

Hi,

Thank you. I inserted the code into my command button but it doesn't seem to be running?

Capture.PNG

.
If I place my desktop path in the fName string, it creates a PDF copy here.

ex: Fname = "C:\Users\My\Desktop\" & Format(Now, "yyyymmdd") & Sheets("Invoice").Range("J6").Value

If you are at home and not work, try using your desktop path.

Excellent. Thank you so much!

You are welcome