Copy excel file to subfolder

M

Myrna Rodriguez

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 here:
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPY EXCEL FILE 2
Macro to copy files from Folders/Subfolders 3
Print contents of sub folders 1
Copy files in sub folders to a specific directory 1
Need to Copy Files (all Subfolders and Files) 2
Create subfolders in a folder 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Skip password protect files and open non protected files 9

Top