I would like to copy the data from a work book that I know is open, however i do not know the full name of the workbook
I do know the work book name will be in the format
mm RED1234567 ddmmyy.xls and the sheet name will beRED1234567
Using just this RED indicator is it possible to copy the...