Macro to open file with specific name from cell

Hi,

I have a piece of code which is intended to open some specific file. the file name comes from a cell. My problem is, I wanted to VBA to see the value from cell, search the entire folder and open the file where the file name contains the cell value.

> If cell value is 4546 then it opens "4546.xls"

I wanted it to be

> if cell value is 4546 it can open file names like "4546_sadsd.xls" or "sdfhjdfs_4546.xls" or "sfsdfs_4546_safdsfs.xls"

I am using wildcard for it but it seems that it is not working.

Also one more point. The file wanted to open is having links to other files. So when the VBA trys to open that, it asks for whether to Update or not. I don't want that pop-up to be showed. I have applied the Application.DisplayAlerts = false but its not working. Any idea why?

Any help will be greatly appreciated.

Please Login or Register  to view this content.

Try this...

Please Login or Register  to view this content.

Sorry....its not working......
Is it working for you? I have also tried several things in the same way but it seems that nothing is working.

Yes it works for me.

What exactly do you mean by "its not working"? Does it error? Not find a file? What?

Did you use this exact code?

What exactly is in Cells(3,3) ?

Thanks a lot for your assistance..

Yes. I have used the exact code of yours. It says file not found. Find the ZIP file which contains all the things with the screenshots.

regards
Sbehera

It works for me using your Master.xls file.

If you're using a Mac, this wont work.

Is your Master.xls file saved in the same folder as your 629_abcdef.xls file? It should be with this code.

Yes... The 629_abcdef.xls is saved in the same folder and I am using windows...

Is your 629 file an .xlsx or .xlsm file?

If yes, try this...
MYFLNAME = "*" & Cells(3, 3).Value & "*.xls*"

Otherwise, I'm stumped.

Hi AlphaFrog , Once again thanks a lot for your patience and efforts.. Finally i have figured out what was going wrong. When I changed the highlighted to MYPTH, It is doing as good as it should..thanks lot...

Please Login or Register  to view this content.