Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA
Resolved · Low Priority · Version 2007
Reply 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
For upcoming training course dates see: Pricing & availability
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\" & strFolder
You 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
Wed 18 Feb 2009: Automatically marked as resolved.
|