Multiple file opening and naming

[daverunt]

Hi,

I open multiple .csv files with varying names using the following code and have stuck in a a Msg box to check the filenames, but what I want to do is give a variable name for each file as it opens, file1, file2 etc so I can use this variable to activate each file when I need it later in the code. Or is there a way to use the filenames index to do the same?

Please advise.

Please Login or Register  to view this content.

[salimudheen]

Hi,

Instead of using for loop, you can try with for each statement,
Idea is,
dim file as string

Please Login or Register  to view this content.

Hope its work.....

Regards,
Salim

[mudraker]

salimudheen

Please take a couple of minutes and read ALL theForum Rules then wrap your VBA code (Rule 3)

[daverunt]

Hi Salim,

Thanks for your reply. It's tidier for sure, but what I need to do is access the files individually to work on them once they are opened.

Say I have 3 files opened how do I activate each one?

I am assuming, because I don't know, that the files need to be given a variable name as each one is opened.

Thanks,

Dave