Message 1 of 2
GoExcel.Open Already Open Excel Document

Not applicable
03-02-2021
11:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Ill keep this short and sweet. The short version is I'm trying to open an Excel Sheet (Ill call it ExcelData for now) and read in inputs and compare them to values in iProperties in Inventor. That all works and is great, the only issue I have is when more than one person tries to access ExcelData at once.
Using GoExcel.Open creates an issue when two people try to access ExcelData at the same time, it throws the prompt that ExcelData is locked for editing, and then shuts down the macro. Is there an alternative to this, or some way to amend this and have it open in like a read only mode or something of the sorts?