Refer to Workbook name using wilcard

Hello,

I have a workbook with a button that does the following: User downloads an excile file from the internet, then activates a workbook i created that has a button, that basically copies all the info on the downloaded file to it. The button on a workbook has the following code:

Please Login or Register  to view this content.

The problem is that the "randsf" workbook is a temporary file downloaded from the internet that is only named "randsf[1]" if it's the first file downloaded by the user since starting their computer, otherwise it could be named randsf[6], and the user will then get the error message.

Obviously i've found that it's not as simple as changing the reference to "randsf*", and i've also tried the following (found online sometime ago??) with no success:

Please Login or Register  to view this content.

Any help would be appreciated. This is an issue that has reared i's ugly head every couple months for the last year or so, and just cant seem to figure it out.

Why don't you delete the downloaded file, after you have done with it ?

@JOHN H. DAVIS,

does the OP need the last downloaded file or the all the downloaded file like "*randsf*

xlbinez: it's always deleted or closed once after the process is over with. I suppose i could write that into the macro, but i'm not sure how that will address teh current issue.

Marc L: That would be great and definately the bet solution, but something i'll have to approach IT about it. I try to avoid them if possible as they always look at me like I have 3 he
ads when I ask them a question and their real protective of their domain. The minuses may outway the pluses.

yudluger: 'name = Workbook.name

John H. Davis: I trid to incorporate your suggestions as follows and it's going to the ErrMessage even if the temp file is open

Please Login or Register  to view this content.

I removed the part you had that activated the temp workbook, because I only want to refer to it for copying it. I want the workbook with the button that does all that to remain activated.

Does this work?

Please Login or Register  to view this content.

could this be the issue of case (upper or lower case)

can you try changing this line of code
from :

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

If you remove this line of code, which I left out on purpose , do you get any errors?

Please Login or Register  to view this content.

If you don't then try using xlbzines suggestion to make the check case insensitive.

Can you post the debug output of all wb.name in your for loop

Please Login or Register  to view this content.

If you used the exact code I posted you wouldn't get any error messages.

The code would loop through all the open workbooks in and if the one you want isn't find that would be it, the code would end.

If you want a message if the file isn't found.

Please Login or Register  to view this content.