Please help to write macro and locate files using "wildcard" feature!

[deve8ore]

Hello,

I have built a macro to automatically go to a specific directory and a specific folder, however the names of the files I need to automatically locate change names every month.

I.e. - I hit the macro button and I'd like to automatically open a (pdf,xls,doc) file:

"C:\Matt\Files\Pricing\Reports\GrossMargin\9279Reb ateDetail.xls"

The only part of the file name that changes every month are the first four numbers before "RebateDetail", and it's the only file with that name in the folder.

Can anyone assist with the code needed to automatically open the "RebateDetail" file, regardless of the preceeding four digits?

Thank you!

Matt

[QVeen72]

Hi,

Add a FileListBox Control on the Form..
And Set the Path, and Pattern properties, your FileListBox is populated with all the Files from that path..
Check this :

 
File1.Path = "C:\Matt\Files\Pricing\Reports\GrossMargin"
File1.Pattern = "*RebateDetail*.xls"
File1.Refresh
 

Regards
Veena

[deve8ore]

Veena, Just wanted to say thank you for the reply, it is appreciated!

[QVeen72]

Hi,

Glad to help you... :)

Regards
Veena