Thread: Wildcard
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert[_30_] Robert[_30_] is offline
external usenet poster
 
Posts: 44
Default 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