The use of wildcards in excel file names in VBA

[Steve2107]

Good evening, the code below relates to the opening of a file with a value specified in the

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The above macro opens a file and retrieves information from it, the idea is for the code below to then go and close that file.

Please Login or Register  to view this content.

The problem I am having is that the above code returns the message "Compile Error: Expected: list separator or )"
I am obviously not placing a "&" in the right place. Any assistance would be greatly appreciated.

[PCI]

You could put the spring

Please Login or Register  to view this content.

in a variable and watch it.
What do you want to put before

Please Login or Register  to view this content.

Just "

[bakerman2]

Please Login or Register  to view this content.

[Steve2107]

Thank you so much for that, I can see quite clearly what your logic is and I should have seen it myself. All it takes sometimes is for someone else to point it out. Have a lovely Christmas.

[PCI]

Thank you and Happy new year
Enjoy Excel

[bakerman2]

Glad to help and thanks fpr rep+.