PDA

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.