VBA - open a filename, print, close, open the next

[jsolomon]

Hi, I have about 150 filenames (all of which are in the same directory) in an excel column (a1:a150 we'll say). I would like vba to read the filename from the cell starting with a1, open that filename, print it, close it then open the next one in the list (a2). I will probably have to use VBA. What is the best way to do this?

thanks

joe

 

[Norie]

The first For Each is going through every cell (c) in a range (Rng).

The second one is going through every worksheet (ws) in the workbook (wb).

 

[jsolomon]

so does every "for" command have to have a "next"?

 

[Norie]

Yes.

 

[jsolomon]

i see, so it really has no other purpose than to close the "for" command? What site would you recommend as a tutorial for the basic VBA syntax? I am really anxious to learn it as I can see really see it's power.

thanks again for your patience and help

joe