Thu 12 Mar 2009, 16:41Delegate Chris said...
Chris has attended:
Excel VBA Intro Intermediate course
File manipulation
How can I take a list of filenames and paths within Excel and use VBA to copy each file to a specific location?
Fri 20 Mar 2009, 11:36
Edited on Fri 20 Mar 2009, 11:36Trainer Stephen said...
RE: File manipulation
Hi Chris
Thanks for your question
You can save your file using the saveas method of the workbook object
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Development\My Documents\" & strFolder & "\" & strFile & ".xls"strTrust is a folder in mydocuments and strFile is the file name
If you want you can create a folder using the MkDir commmand
MkDir "C:\Documents and Settings\Development\My Documents\" & strFolderHope that helps
Regards
Stephen
