How to attach already opened excel?

Hi,
I'm trying to get collection from opened excel, and this excel was not saved in the resource machine Is it possible to get data by using default MS excel VBO ?

harish17 said:

Hi,
I'm trying to get collection from opened excel, and this excel was not saved in the resource machine Is it possible to get data by using default MS excel VBO ?

Click to expand...

hi @harish17
Is that possible to drag data from any not saved file,Jus think abt it.
In my knowledge there is possibility to access or extract data from a non save file.

@Harish 17 , in utility ms excel vbo there is action to attach open excel and use get collection as fast to retrieve data from collection.

Might help you

Hi sanjiv,

Thanks for your response. I tried using Get collection previously since it is throwing error "invalid file name Thought it wont work for 'Get collection as fast' as well. Anyway thanks again Now able to fetch data from opened excel workbook.