tough one for me: access open excel workbooks that are NOT saved anywhere, need help

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

unfortunately, no, does not work
the workbook does not react to any commands

but thanks, this was quick!

Please Login or Register  to view this content.

[/QUOTE]

it gives an error for the "in" in "for wbk in application.workbook
just red text, expects an = etc

Originally Posted by Chandrajit

I think the code should read

Please Login or Register  to view this content.

syntax is ok now, but it does still not work. the macro start, seems to run through (i only have a cell offset in the script for testing purposes), but there is no reaction in the open files

no, their not. the software is opening a new instance

i think every workbook is a new instance, not only the one with the code

thnks for the help btw, and greetings to your pharmacist wife (strictly platonic

still doesn't work, sorry

seems to work. i tried to emulate the conditions from work at home. will test at, otherwise i will reopen the thread

thanks, you really are the guru!