Hi

I have the following problem in excel VBA:

I need to open a file with the name run1mmyyyy.

For example it must be opened for the months november 2006 to february 2007

How can I determine in vba code how many files must be open.
Because febr.2007 is the second month and november2006 the 11th.

Hope it's clear what I want en hope you can help.

Best regards
Jan