Posted to microsoft.public.excel.programming

Valeria[_2_] Valeria[_2_] is offline

external usenet poster

Posts: 24

for-each-next loop

Dear experts,
I would like to open through a macro each of the workbooks
that are in a certain folder. (Their number and names can
vary over time).
I wanted to use the FOR EACH... IN... NEXT loop, but it
does not seem to work (I get a "Type mismatch" error
message). Do you know how I could perform this?
Many thanks in advance.
Regards,
Valeria

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
for/next loop	Poor Richard	New Users to Excel	3	August 31st 09 09:28 PM
For..Next..Loop	default105	Excel Discussion (Misc queries)	12	July 7th 09 07:46 PM
Find loop doesn't loop	JSnow	Excel Discussion (Misc queries)	2	June 24th 09 08:28 PM
Loop help	PaulW	Excel Discussion (Misc queries)	0	May 8th 06 04:00 PM
getting out of a if loop	rk0909	Excel Discussion (Misc queries)	3	April 11th 06 03:55 PM

All times are GMT +1. The time now is 08:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us