Excel application scope how to save data keeping file open


#1

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,


#2

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


#3

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


#4

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


#5

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


#6

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