Radsam Posted March 6, 2008 Share Posted March 6, 2008 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 Link to comment Share on other sites More sharing options...
amokoura Posted March 6, 2008 Share Posted March 6, 2008 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?ThanksI 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. Link to comment Share on other sites More sharing options...
Radsam Posted March 6, 2008 Author Share Posted March 6, 2008 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? Link to comment Share on other sites More sharing options...
amokoura Posted March 6, 2008 Share Posted March 6, 2008 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. Link to comment Share on other sites More sharing options...
Radsam Posted March 6, 2008 Author Share Posted March 6, 2008 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. Link to comment Share on other sites More sharing options...
Radsam Posted March 6, 2008 Author Share Posted March 6, 2008 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 Link to comment Share on other sites More sharing options...
Radsam Posted March 6, 2008 Author Share Posted March 6, 2008 bump Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now