Select/close the previously activated workbook

[rosshkerr]

Hi Guys

I have a tracker file that I use many times a day that copies data from a downloaded spreadsheet (Facility Tracking)using VBA. We are now using Microsoft edge. The trouble is, in Edge the file is still showing in the download list so the downloaded file name changes, I get a (1), then a (2) after the file name, which stops the import macro from working as it uses the standard file name, Facility Tracking, to close the file once the import is complete. I have tried using wildcard type things (Facility Tracking * for example) but this will close either file as the names are similar. is there a way of just selecting or activating the previously activated file so it can be closed? I have Googled it but couldn't find anything that worked for me. This never used to be a problem with Internet Explorer and we don't have Chrome installed on the work computers

Thanks for looking

[Artik]

The whole thing should be written quite differently. But, to change as little as possible at the moment, you can apply your own function which will try to search for the relevant workbook.
Only the CopyData procedure is changed plus the FindBookName function.

Please Login or Register  to view this content.

Artik

[rosshkerr]

Hi Artik

I know my macro writing skills aren't great but I have figured a lot out myself over the years and tend to make do with what works. Never had the time to learn it properly. Anyway, your fix works perfectly, many thanks for your help, much appreciated

Cheers

Ross