Excel application scope how to save data keeping file open

Hi,

I have an excel that needs to be open with admin rights and it has link to a desktop application.
It update data (dynamic price of stock)in the excel every 5 sec. I have to keep the excel open and pull data outof it.

Can you suggest how to save the excel without closing it.

Regards,

You can use the Send Hot keys activity - Ctrl + ā€˜Sā€™ to save the file.
Make sure the focus is on Excel Window.

Regards,
Karthik Byggari

Nopeā€¦ that will not work as the excel application scope will open the excel in read-only mode

By default the file will be opened in write-mode.
In the excel application scope, in the properties panel, disable Read-only if enabled.

You can even enable Auto-Save option in the Excel Application Scope to avoid explicitly saving the file.

Regards,
Karthik Byggari

Nope!! i think you did not get the queries to open the excel i have to right-click and open as admin otherwise links in excel will be broken.

i already hve tried the send hot key. but my case excel will be open in read-only mode.

can you pls suggest

Before opening the file, can you try removing the read-only option. Right-Click on file ā†’ Properties-> Remove Read-Only.