Hi,

I usually have 2-3 files open when running this process and download a file from a web based program which opens an Excel file which is usually called "PL Invoices" but is sometimes called "PL Invoices (1)" or "PL Invoices (2)" (I've not seen higher numbers, but I suspect they're possible - the numbers seem to relate to the number of times I've run the report (e.g. if the macro crashed because I forgot to change something), so I am unlikely to get PL Invoices (3) or higher, if that helps).

I am trying to activate this file so I can copy and paste data (in the rest of the macro) into another file inconveniently called "PL Invoices 16/17" (relating to the financial year).
In the rest of the process I need to swap and change a couple of times between the files, so it would be nice to find/obtain the file name and be able to use it as a variable.

Can you help, please?

Thanks :-)