Running A Macro On A List Of Worksheets 2

[ADE6]

Hi,

I have a workbook that contains a worksheet called CALC , in column A of this worksheet I have a list of other worksheets that I would like to run a macro on.

Would it be possible to set up some code that would select the worksheet at the top of the list, perform a macro then select the next worksheet in the list and carry out the macro on that sheet until all worksheets that appear in the list have been updated.

Thanks for the ideas.

Ade

 

[SkipVought]

Hi,

Please post code questions in VBA Visual Basic for Applications (Microsoft) Forum707.

Skip,
[sub]
[red][/red]
[/sub]

 

[Gavona]

This may get you started but if you need any further help You should post in the vba forum.

Record yourself opening the sheets and observe the code.
Rework it using a for Next loop as below

Dim c as range
For each c in Range("Mylist")
open c.value
do some stuff
next c

you might need to add the path within your code if not in your workbook.

Mypath = "C:\my documents\"
MyFile mypath & c.value
Open MyFile
regards,


Gavin

 

[SkipVought]

"...I have a list of other worksheets that I would like to run a macro on."

A WORKSHEET is an object within a WORKBOOK.

Are we talkin' 'bout a list of Worksheets or Workbooks?

Skip,
[sub]
[red][/red]
[/sub]

 

[Gavona]

You're right, Skip, I should have read the post properly!


Gavin