Kristina96
New Member
- Joined
- Sep 30, 2019
- Messages
- 33
Hello all,
In have a file path saved as the variable "File_Path". Now I want to save a workbook to that path.
I'm using the following code:
It is not recognising "File_Path" as the variable though. What do I have to change?
Thank you and regards,
Kristina
In have a file path saved as the variable "File_Path". Now I want to save a workbook to that path.
I'm using the following code:
Code:
WB2.SaveAs Filename:= _ File_Path _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
It is not recognising "File_Path" as the variable though. What do I have to change?
Thank you and regards,
Kristina