VBA to Open workbook with part file name

[hblbs]

Hello

I have a file name "Work_outstanding_010411.xls". I am trying to open the workbook with VBA using only part of the file name, see below.

Workbooks.Open Filename:="C:\Work\Work_outstanding_*"

But I keep getting error saying the workbook can not be found.

Is it possible to open a workbook using the beginning of the file name only as opposed to the entire name? The beginning is always the same however the date only changes.

Thanks

 

[Trevor G]

I think you will need to add the & ".xls" to the end as you need to reference the file extension.

 

[hblbs]

Hello thanks for the reply, even with the file extension I get the same error message.

Any help is appreciated.

Workbooks.Open Filename:="C:\Work\Work_outstanding_*.xls"

 

[RSXchin]

Workbooks.Open Filename:="C:\Work\Work_outstanding_*" & ".xls"</pre>

 

[Trevor G]

Hello thanks for the reply, even with the file extension I get the same error message.

Any help is appreciated.

Workbooks.Open Filename:="C:\Work\Work_outstanding_*.xls"

Change the end as indicated below:

Workbooks.Open Filename:="C:\Work\Work_outstanding_*" & ".xls"
</PRE>

 

[hblbs]

Hello I have tried the following but unfortunately the same error is given.

Workbooks.Open Filename:="C:\Work\Work_outstanding_*" & ".xls"

 

[olharris]

Hello I have tried the following but unfortunately the same error is given.

Workbooks.Open Filename:="C:\Work\Work_outstanding_*" & ".xls"

The number of * characters must equal the number of expected characters to follow _outstanding_. For example, if it were a date that was following in mm_dd_yy format, you would enter ********, or 8 *.