Wildcard

[Robert]

Hello,

Through a macro statement I want to open an excel sheet from a pre
defined folder. As this folder always contains only one sheet (names
differ though) I was wondering if I can give add a wildcard to the
path.

For example something like:
Workbooks.Open Filename:= _
"H:\Risk_Management\Special_Review\Upload_files\*.xls"


Thanx a lot for your help and time.

Rgds,
Robert

 

[Bob Phillips]

Use something like

sFilename = dir("H:\Risk_Management\Special_Review\Upload_files\*.xls"
Workbooks.Open Filename:= sFilename

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)