topic Re: Running a VBA form to access excel spreadsheet with excel application minimi in Inventor Programming Forum

Running a VBA form to access excel spreadsheet with excel application minimized

MCCJohnPetty — Fri, 08 Nov 2019 13:10:38 GMT

I have a vba userform that accesses an embedded spreadsheet to drive a multibopy part design. the issue is I do not want the excel application visible (minimized would suffice). I am able to get the spreadsheet to not show (See snippet below), but I still get the excel application popping up.(see attached image.

Is there a way that I can get the excel application to "disappear" so that the end user only sees the form and the inventor application?

Thanks in advance

Set eApp = Excel.Application
With eApp
.Application.WindowState = xlMinimized
.Visible = False
.ScreenUpdating = False
.WindowState = xlMinimized
End With

Re: Running a VBA form to access excel spreadsheet with excel application minimi

MCCJohnPetty — Fri, 08 Nov 2019 13:32:44 GMT

Another question in regards to the vba userform:

Is there a way that I can code in the ability for the ipt to do a local update (or global update)?

I currently have this "ThisApplication.ActiveDocument.Update" at the bottom of my build code, but it doesn't seem to work as expected.

Re: Running a VBA form to access excel spreadsheet with excel application minimi

fullevent — Fri, 08 Nov 2019 15:49:41 GMT

Hello @MCCJohnPetty,

depending on how your code is structured, you may be able to fix this by bringing the Inventor application into the foreground (activate it) at a proper place in the code.. as workaround.

On Update, please try .update2 and .rebuild2
That usually worked for me then.

regards

Re: Running a VBA form to access excel spreadsheet with excel application minimi

MCCJohnPetty — Fri, 08 Nov 2019 16:07:59 GMT

Thank you. I will try it.