|
-
October 10th, 2001, 04:01 PM
#1
excel
I have written an app that calculates data, then goes out and opens an excel spread sheet and loads the data. I'm using excel because I can then sort and filter the info retrieved later. My app is being used on a network, so multiple users could possibly attempt to write to the spreadsheet simultaneously. I have 2 questions:
1.)How can I check to verify that the spreadsheet is not currently open / being written to?
2.)I would also like to retrieve this data and bring it back to my application, would It be a better approach to attach it to an Access Database? I'd like to be able to scroll forward and back to view /search each record. (If so, how would multiple users work in Access?)
I would deeply appreciate any reply,
Thanks---Jay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|