GoExcel.Open Already Open Excel Document

GoExcel.Open Already Open Excel Document

Anonymous
Not applicable
592 Views
1 Reply
Message 1 of 2

GoExcel.Open Already Open Excel Document

Anonymous
Not applicable

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?

0 Likes
593 Views
1 Reply
Reply (1)
Message 2 of 2

bradeneuropeArthur
Mentor
Mentor

could you give me a filename of the excel file that is to be opened?

 

imports System.io
Dim a As New System.IO.FileInfo("F:\Excel\filename.xls")

If a.IsReadOnly = False Then
	GoExcel.Open("F:\Excel\filename.xls", "Sheet1")

	End If
	

Regards,

Arthur Knoors

Autodesk Affiliations & Links:
blue LinkedIn LogoSquare Youtube Logo Isolated on White Background


Autodesk Software:Inventor Professional 2025 | Vault Professional 2024 | Autocad Mechanical 2024
Programming Skills:Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Programming Examples:
Drawing List!|
Toggle Drawing Sheet!|
Workplane Resize!|
Drawing View Locker!|
Multi Sheet to Mono Sheet!|
Drawing Weld Symbols!|
Drawing View Label Align!|
Open From Balloon!|
Model State Lock!
Posts and Ideas:
My Ideas|
Dimension Component!|
Partlist Export!|
Derive I-properties!|
Vault Prompts Via API!|
Vault Handbook/Manual!|
Drawing Toggle Sheets!|
Vault Defer Update!

! For administrative reasons, please mark a "Solution as solved" when the issue is solved !


 


EESignature

0 Likes