Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy an excel file to new created folder
Hello VB addicts!
I programmed a macro to create folders on the main directory(ex: S: directory) When a user enters a file number in excel, a batch of folder will be created. For each file folder batch created, I will need to include an excel file. How can I automate this procedure? Currently the excel file is saved on the S: directory. Thanks in advance for you help and continue to enjoy life! myrna *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy an excel file to new created folder
Look up "Workbooks Collection" in Excel Help. Look at its methods like Add,
Save and SaveAs. "Myrna Rodriguez" wrote in message ... Hello VB addicts! I programmed a macro to create folders on the main directory(ex: S: directory) When a user enters a file number in excel, a batch of folder will be created. For each file folder batch created, I will need to include an excel file. How can I automate this procedure? Currently the excel file is saved on the S: directory. Thanks in advance for you help and continue to enjoy life! myrna *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy an excel file to new created folder
Try the following:
MkDir path where path is a string. You can assemble the string on the fly by concatenating the user input onto the rest of your path statement as necessary. Then create your file by using the SaveAs or SaveCopyAs commands (check help). I save a copy of a workbook by doing the following: fileName = MyPath & SaveFileName & ".xls" ActiveWorkbook.SaveCopyAs (fileName) Where SaveFileName is a variable I use to assign a user input value. fileName is also a variable that includes the full path to the directory where the file will be saved. Hope that helps! Kevin -----Original Message----- Hello VB addicts! I programmed a macro to create folders on the main directory(ex: S: directory) When a user enters a file number in excel, a batch of folder will be created. For each file folder batch created, I will need to include an excel file. How can I automate this procedure? Currently the excel file is saved on the S: directory. Thanks in advance for you help and continue to enjoy life! myrna *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i created a macro in a xlstart folder.how do i do to insert in too | Excel Discussion (Misc queries) | |||
how do I copy an Excel file created in XP to Vista on a new comput | Excel Discussion (Misc queries) | |||
Open and copy all workbook sheets in a folder to a master file | Excel Discussion (Misc queries) | |||
save workbook created from templete to a specific folder | Excel Discussion (Misc queries) | |||
Create a copy in the same folder when a file is modified and saved | Excel Discussion (Misc queries) |