hi guys,

first, let me shortly describe the problem. i operate a pharmaceutical research robot. the robot works automatically, by nature, and he works over night. he outputs some data into excel workbooks. because he keeps opening new workbooks for each plate (what is physically analyzed) he process, it ends with 40 or so open workbooks, which are not saved anywhere, and are named Book1, Book2 etc (no .xlsx ending or so). I want to develop a script, that then saves each of these files to a specific folder and start a data analysis (the data analysis part is ready). so far it sounds easy, right?

the problem i do have, i can't open access the open files with

Workbooks("Book1").Activate

does anybody an idea?

thanks