Using macros to open 10 files?

[MACROSCRIBER]

How do I select open and close 10 excel files indivualy and sequentially
perhaps they would be file 1 file2 file3.......?

 

[Norie]

Like this perhaps.

Dim wb As Workbook

For I = 1 To 10
     Set wb = Workbooks.Open(Filename:="C:\File" & I & ".xls)

     ' do stuff with workbook here

     wb.Close

Next I

 

[MACROSCRIBER]

almost there

thanks for the code but the set line buggs out when i try to runit
heres is how i can write my idea for 3 files instead on 10


a$(1)="file1.xls"
a$(2)="file2.xls"
a$(3)="file3.xls"

for n=1to3

open excel file a$

do other macro stuff here

close excel file a$

next n


how would i do this with vba macros?

 

[Norie]

How does the code 'bug' out?

It's only really an example and would have to be adapted for your particular situation.