VBA excel save as PDF in specific location

[Eddy08]

Im really getting frustrated and on this for a few days (not an excel expert at all)

My question is:

I have the last part of my VBA correct, which removes written data in specific cells, adds a number in a specific cell (invoice number), changes the date to the correct
date and prints 1 copy.

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False

Range("C3:D5").ClearContents
    Range("B1").Select
    Range("F1").Value = Date
    Range("B1").Value = Range("B1").Value + 1

the first part however, wont work. Is it possible for my excel file to be saved in multiple locations with different extensions.
I want 1 file to be exported as PDF in a networkfolder in a subfolder called PDF
and I want 1 file to be save as excel file in the same networkfolder but then in a subfolder called EXCEL.

 

[John_w]

Welcome to MrExcel forums.

For the PDF, record a macro with you saving the whole workbook/active sheet/selected sheets (it's not really clear what you want) as a PDF in the PDF subfolder. The generated code can then be incorporated into the overall macro.

For the Excel file, do you want save it as a macro-enabled workbook (.xlsm) or as a worksheet (.xlsx)?