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

[MCCJohnPetty]

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

[MCCJohnPetty]

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.

[fullevent · Accepted solution]

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

[MCCJohnPetty · Accepted solution]

Thank you.  I will try it.