Macro to save as, to specific folder

[wolfm]

Hello:
Looking for VBA code to automatically save an excel file as an .xlsx format, and saving to a specific folder: C:\Users\wolfm\Desktop\Load Lists

I have been using the attached code, but it's not working. It saves to the desktop, not the folder. Also, when it creates the file name based on sFile = ActiveSheet.Range("C4").Value & ".xlsx", it adds wierd things to the file name. I want the file name to be simply the value in C4.

Any help is greatly appreciated!

Please Login or Register  to view this content.

[HaHoBe]

Hi, wolfm,

aren´t you missing a backslash for the folder like

Please Login or Register  to view this content.

Ciao,
Holger

[wolfm]

Great! That worked! Thank you, Holger!