Macro to open files based on string variable

**Coeus** · 02-11-2013, 05:44 PM

Hi all!

Another saga in my macro development. If someone could please advise how to do (if possible!) the requested would be much appreciated.

Basically I have a workbook with some titles in a row, say AAA BBB CCC DDD etc.

Each of these titles represents a workbook to open in the same directory (i.e. AAA is the title of one workbook, BBB the title of the next etc.)

I am drafting a macro but a bit stuck on how to tell Excel to use the string variable stored in a single dimension array (the workbook row with the titles contained within) as the last part of the filename directory e.g.:

C:\My documents\AAA
C:\My documents\BBB
C:\My documents\CCC

My macro as it stands:

Please Login or Register  to view this content.

If anyone can help would be much appreciated!

All the best,

Coeus.

**JosephP** · 02-11-2013, 06:40 PM

Please Login or Register  to view this content.

**Alf** · 02-11-2013, 06:47 PM

You could try something like:

Please Login or Register  to view this content.

Where you have stored the strings in cell B2 to B5

C:\My documents\AAA\
C:\My documents\BBB\
C:\My documents\CCC\
C:\My documents\DDD\

Alf

Ps When you post code don't forget to wrap it!