Open file and run macro based on partial file name

[PaulM100]

So I have the following code that should open a workbook and run a macro then close it, but obviously it doesn't work. Anyone has any ideas how to make it work? I added 2 new lines believing that I need to return the name a string, but it doesn't work either.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Fluff13]

Try

Please Login or Register  to view this content.

[PaulM100]

Thank you fluffy, that indeed, solved my problem. But now I get an runtime-error 13 on this line:

Please Login or Register  to view this content.

[Fluff13]

That should just be

Please Login or Register  to view this content.

[PaulM100]

Oh, cause we've already declared it. thank your for your solution

[Fluff13]

You're welcome & thanks for the feedback