Thu 8 Jan 2009, 16:35Delegate Hugh said...
Hugh has attended:
Excel VBA Intro Intermediate course
VBA
bets way to make a filepath to another workbook which i can change easily
Wed 11 Feb 2009, 15:37
Edited on Wed 11 Feb 2009, 15:38Trainer Stephen said...
RE: VBA
Hi Hugh
Thanks for your question
It is possible to create a new folder at a particular location by using the mkdir function.
For example, the following code will create a new folder in my documents. The folder's name is specified by the variable strFolder.
MkDir "C:\Documents and Settings\Development\My Documents\" & strFolderYou could also use the SaveAs method to save a file to a particular directory
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Development\My Documents\" & strFolder & "\" & strName & ".xls"Hope this is useful
Regards
Stephen
