LinkBack URL
About LinkBacks
Hi everybody.
Can someone demo code update data from multiple files in multiple folders into one workbook (Multiple sheets).
Each sheet updates a folder.
Thank you.
Hi everybody.
Can someone demo code update data from multiple files in multiple folders into one workbook (Multiple sheets).
Each sheet updates a folder.
Thank you.
You dont (necessarily) need code for this. You could just use regular formulas to link the Source files to the Destination file, in exactly the same way you would link worksheets to a summary worksheet in the same file.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
maybe something like these:
example
adjust to suit the files and sheets
Please Login or Register to view this content.
Thanks everyone.
But not exactly what I mean.
what does that mean?Originally Posted by tax112
wrong answer?
no answer?
something else?
I have many Folders, each folder contains 300 *.text files.
Now I want to update those 300 files for each Sheet.
I already know how to update each Folder data for each Sheet.
But I don't know how to update multiple Folders for many Sheets at the same time.
Can anyone help me write a loop like this:
For i=Folder1 to Folder n
......
Next i
Thank you.
use a variable to change the folder name (I'm assuming the folders are inside a main folder)
@k1dr0ck
Thank you for your reply.
Please help me.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks