Wildcard
 

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

Wildcard
 

Use something like

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Robert" wrote in message
ps.com...
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