Prev: How do you convert a string to a double?
Next: Summary Help Needed
From: JOSEPH WEBER on 15 Apr 2010 10:10
I want to set up a macro that will activate a workbook, copy the info in
specified fields and paste it to the master workbook, then close the original
workbook. I can't figure out how to do this, because I won't know the name of
the workbook that will be activated. I set up a macro that adds a new
workbook and names it based on a cell value and then saves it in a specific
folder. I want to go in that folder, open up all of the workbooks and then
activate the macro that will copy info to the master workbook. Please help
From: sali on 15 Apr 2010 10:25
"JOSEPH WEBER" <JOSEPHWEBER(a)discussions.microsoft.com> je napisao u poruci
interesnoj grupi:3A8360D7-C75D-455D-B453-0AC389344835(a)microsoft.com...
> folder. I want to go in that folder, open up all of the workbooks and then
> activate the macro that will copy info to the master workbook. Please help

after you open your workbooks from specified folder, just do the collection
scan, like:

--------
n = 0
msgbox "total of [" & workbooks.count & "] workbook(s) openned"
for each wb in workbooks
n = n +1
msgbox "workbook [" & n & "] in memory: " & wb.name
next
--------


 | 
Pages: 1
Prev: How do you convert a string to a double?
Next: Summary Help Needed