Open existing Excel file using GoExcel options

Open existing Excel file using GoExcel options

karram
Advocate Advocate
367 Views
1 Reply
Message 1 of 2

Open existing Excel file using GoExcel options

karram
Advocate
Advocate

Using iLogic below code with "GoExcel" options, how can i open Excel file to be the one that exists in the workspace location.

But the important logic is "that file name characters changes all the time and last three characters always be "000". 

 

This kind of case how to access the Excel file name

 

 

GoExcel.Open("Excelfilename", "Sheet1")

 

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

A.Acheson
Mentor
Mentor

Does the filename in any way match the assembly. part filename? If not you will need to search the folder directory for all excel files and check then if they contain "000". 

This post here covers it well. 

https://forums.autodesk.com/t5/inventor-ilogic-and-vb-net-forum/find-and-open-excel-file-in-folder/t...

If this solved a problem, please click (accept) as solution.‌‌‌‌
Or if this helped you, please, click (like)‌‌
Regards
Alan
0 Likes