View Full Version : Solved: [Excel] Open files listed in varialble, extract data
realitybend
06-25-2008, 03:30 PM
I need to copy O1:O4 in multiple workbooks in a certain folder; the names of these workbooks are stored in the variable FileList, and also, pasted in row one of the sheet. How would I open each file, extract the data, and copy the file into the sheet that was previously opened (named "Money").
Thanks.
lucas
06-25-2008, 08:35 PM
Hi realitybend, Welcome to VBA Express. You are going to have to give us a little better clue as to your objective. I would suggest a sample workbook or two if necessary to make your objective clear.
Some better understanding of what you are trying to do would help too. For instance, I don't understand what 01:04 means. Is that a column/row reference?
What is the variable Filelist and where does it reside........questions, questions. You have to make your problem clear or it is hard to help.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.