o put all of these into a single workbook, then
you'd have to record the macro in which you move the sheet from the new
workbook to the "Archive" workbook...
How is that different than what you're looking for?
Paul
____
From: mmccaws2
To: M
Sorry for the delay. I've never worked with microsofts programming
languages, so I've been experimenting when I have time.
Here is what I've learned from monkeying around with the macro
recorder. The file selected when using the "Data -> input external
data" function has a name property. And I
Hi Mike,Check the article below
http://funwithexcel.blogspot.com/2009/05/how-to-copy-multiple-workbooks-data.html
This helps in copying many small files into a single excel workbook and each
file gets it's own sheet.
On Mon, Jun 1, 2009 at 1:34 PM, mmccaws2 wrote:
>
> Hi
>
> Maybe I'm not using
Am I missing part of this thread?
Or is this a new topic?
If it's new... what you're asking is fairly simple.
But I need more info.
Are the files in a single folder?
What is the format of the name that you want to parse to get the third "word"?
like: "file_For_Tommy.xls", "file For Tommy.txt", w
