Copy excel file to subfolder
 

Hi...

I created a sub folder called Title Work under main folder called 04_X.
X=cell value in excel
d = "S:\Order Folders\2004 Open Orders\" & "\04_" & cell.Value & "\Title
Work"
Mkdir d

***My problem is he
I am trying to copy an excel file to that sub folder.
I believe the excel file QA.xls is not recognizing 04_cell.value. How
can I copy QA.xls to the subfolder??

I tried this code:
FileCopy "S:\Order Folders\QA.xls", "S:\Order Folders\2004 Open
Orders\04_ & cell.Value\Title Work\QA.xls"

This is my file folder sequence:
Order Folders
2004 Open Orders
04_XXX (this is the main file folder)
Title Work (subfolder)
QA.xls (wish to have this file in subfolder Title Work)

Thanks much for your help & continue to enjoy life!!
Myrna



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!