Hello,
How would I go about defining the location of an excel file in ProjectWise so I can open it from MicroStation in VBA? I currently have a userform that has a text box that users enter the excel file location manually (tbWBLocation). See the inserted code for more.
Thanks,
'Get an Excel workbook Dim oWorkbook As Excel.Workbook 'this removes the extra quotes from the file location tbWBLocation = Replace(tbWBLocation, """", "") 'tests if file exists If FileExists(tbWBLocation.Text) = False Then GoTo WBLocation_NOT_FOUND End If Set oWorkbook = oExcel.Workbooks.Open(tbWBLocation.Text)
Hi Joey,
I recommend to move your question to ProjectWise Programming forum (use More > Move tool).
MicroStation does not provide any API to cooperate with ProjectWise, especially when it's even not design file but Excel file, so in my opinion it will be better to ask in ProjectWise community what API to use. When it will be clear, maybe further step - to discuss how such API call from MicroStation environment - will be necessary. But at first it has to be clear what ProjectWise API should be used.
With regards,
Jan
Bentley Accredited Developer: iTwin Platform - AssociateLabyrinth Technology | dev.notes() | cad.point