Sign in to follow this  
Followers 0
Radsam

Update Excel File while already open

7 posts in this topic

Excel makes it so you can't have multiple copies of the xls file opened at the same to write to.

What I need to do is to be able to have multiple people write to the same xls file potentially at the same time.

Is there any way to do this using Locodarwin's Excel UDF?

Thanks

Share this post


Link to post
Share on other sites



Excel makes it so you can't have multiple copies of the xls file opened at the same to write to.

What I need to do is to be able to have multiple people write to the same xls file potentially at the same time.

Is there any way to do this using Locodarwin's Excel UDF?

Thanks

I recall there isn't any trick to make an xls file multi-usable. Microsoft might have some Sharepoint stuff to solve that problem but I guess that's not what you want to do.

How about using MS Access? That's usually the next step from spreadsheets.

Another solution would be a program that manipulates the spreadsheet data. That way it would be locked only milliseconds when editing data. The helper program could be made with AutoIt or Excel also.

Share this post


Link to post
Share on other sites

Another solution would be a program that manipulates the spreadsheet data. That way it would be locked only milliseconds when editing data. The helper program could be made with AutoIt or Excel also.

This is what I wanted to do. Is there a way to have A3 detect when/if the xls file is opened for editing so that the script waits for the xls to be closed before continuing with an edit to the xls file?

Share this post


Link to post
Share on other sites

This is what I wanted to do. Is there a way to have A3 detect when/if the xls file is opened for editing so that the script waits for the xls to be closed before continuing with an edit to the xls file?

The Workbook/sheet object has a property that tells that it's in readonly mode. When the A3 script detects readonly, it could possibly sleep a sec and then try to open the sheet again and re-check for editing availability.

Share this post


Link to post
Share on other sites

The Workbook/sheet object has a property that tells that it's in readonly mode. When the A3 script detects readonly, it could possibly sleep a sec and then try to open the sheet again and re-check for editing availability.

I will try this, thanks. If I need more assistance with this, I will post again here.

Share this post


Link to post
Share on other sites

The ExcelCOM_UDF has a function to open a workbook, however, it will open the workbook in read-only if another person has it already it open.

This is not what I would like to have happen.

I would like the A3 script to detect if the xls file is opened (read-only) and if it is opened, wait for it not to be opened then open it in write mode.

Is this possible and if so, please provide example.

Thanks

Share this post


Link to post
Share on other sites

bump

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0