Hi,
From within an excel macro, I need to open another existing .xls
file. This file is one of many contained in a folder, which one that is
required will be dependent on a value assigned to a variable (vSpec).
The file will need to be selected because it contains the data held
within the variable - e.g.;

XXX 123.xls
XXX 234.xls
XXX 345.xls
XXY 456.xls

vSpec = 234 - Therefore XXX 234.xls needs to be opened

Can you please advise what code I need to be able to do this?

Thanks in advance.

Rob Edwards

Always look on the bright side of life!

*** Sent via Developersdex http://www.developersdex.com ***