topic How to open an excel file from VBA in Inventor Programming Forum

How to open an excel file from VBA

jake_egley — Tue, 10 Dec 2024 16:37:45 GMT

I have a macro that fills out an excel spreadsheet and saves it. Now I want it to open the spreadsheet for the user to see when the macro has finished. As opposed to the user going to file explorer to open it after running the macro. I tried several workbooks.open variations and none are working for me. Thank you

Re: How to open an excel file from VBA

marcin_otręba — Thu, 12 Dec 2024 09:30:10 GMT

if you are using excel to fill date then for sure you open it propably invisible ? something like:

Dim XL As Object Dim xlWS As Object Set XL = CreateObject("Excel.Application") XL.Visible = False

then after saving it you can use :

XL.Visible = True

if not then you can use :

Dim XL As Object Dim xlWS As Object Set XL = CreateObject("Excel.Application") XL.Workbooks.Open (bomname)

Re: How to open an excel file from VBA

jake_egley — Thu, 12 Dec 2024 21:07:08 GMT

Works Great. Thank you. Do you know how to open a file explorer window and make it visible? So when the ilogic is done there is a file explorer window open at the location where my excel file is saved.

Re: How to open an excel file from VBA

A.Acheson — Fri, 13 Dec 2024 01:57:26 GMT

Hi @jake_egley

Try this from this help page on stackoverflow here

Dim Foldername As String
Foldername = "\\server\Instructions\"

Shell "C:\WINDOWS\explorer.exe """ & Foldername & "", vbNormalFocus