how do I open other workbooks in excel using wildcards

K

Kiwijohn007

I am trying to open other workbooks that have a date and time stamp applied
to the file name but they also contain a common word as well. In this
instance Queue. What I would like to know is can some code be writen in excel
vba that ignores the first part of the file name and focus's on the Queue
word and opens the file?
 
S

Stefi

Have a look at GetOpenFilename in VBA Help!
Regards,
Stefi

„Kiwijohn007†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

open different workbooks in individual instances of excel 1
How to open two Excel files in separate windows? 4
How to open excel workbooks in SAME instance of Excel 2
break links to other workbooks 4
View workbooks side by side in Excel 2007 12
Opening multiple workbooks in Excel 3
Uisng the Max and Index function to link to other workbooks 1
Problems opening excel workbooks 1

Top