How to save activeworkbook in created folder

**Harrij** · 02-09-2013, 04:52 AM

why won't it accept de var500 discription??
The backup needs to be in the created strFolder
The MkDir works and creates the folder/map.
Now I want the active workbook to be saved in this newly created folder/map.

MkDir ("P:\QC\LAB errors 2013\" & strFolder)
var500 = strFolder
ChDir "P:\QC\LAB Errors 2013\& var500"
ActiveWorkbook.SaveAs Filename:= _
"P:\QC\LAB Errors 2013\& var500\BackupGC.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

**HaHoBe** · 02-09-2013, 05:06 AM

Hi, Harrij,

if it´s a variable you must tell VBA so and not include it in "" (VBA won´t reckognize it there as a variable but only as a string):

Please Login or Register  to view this content.

Ciao,
Holger

**Harrij** · 02-09-2013, 05:44 AM

Did the following........... what else do i need to in VBA ??? HOW do I make this context work???

Dim var500
sub backup()
MkDir ("P:\QC\LAB errors 2013\" & strFolder) ..................WORKS !
var500 = strFolder................ STATES VAR500="BACKUPGCFEB".....so okay
ChDir "P:\QC\LAB Errors 2013\" & var500........................ here no way ... path unknown?????
ActiveWorkbook.SaveAs Filename:= _
"P:\QC\LAB Errors 2013\" & var500 & "\BackupGC.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
end sub

**HaHoBe** · 02-09-2013, 05:53 AM

Hi, Harrij,

where does the variable strFolder get the value? If you are currently not on the drive you need to change the drive first and only after that you may change the folder:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Ciao,
Holger

**Harrij** · 02-09-2013, 07:47 AM

Did the following........... what else do i need to in VBA ??? HOW do I make this context work???

Dim var500
sub backup()
MkDir ("P:\QC\LAB errors 2013\" & strFolder) ..................WORKS !
var500 = strFolder................ STATES VAR500="BACKUPGCFEB".....so okay
ChDir "P:\QC\LAB Errors 2013\" & var500........................ here no way ... path unknown?????
ActiveWorkbook.SaveAs Filename:= _
"P:\QC\LAB Errors 2013\" & var500 & "\BackupGC.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
end sub

**Harrij** · 02-09-2013, 07:49 AM

I am already on the P: drive and var500= strFolder is already defined earlier in the script and has a working var !

**JosephP** · 02-10-2013, 07:24 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here