Closing an Excel Userform from Word VBA

[Helpme21]

Hello -

I'm trying to pull data from an excel document, but the problem is the excel document automatically loads a userform when it opens. So when I open the excel file using Microsoft Word VBA the code gets stuck on this userform until I manually press the "x" button to close it. It there any way to close the excel userform from Microsoft Word VBA code?

Thanks in advance!

 

[Andrew Poulsom]

Can't you just disable Excel's events before opening the workbook? In Excel it would be:

Application.EnableEvents = False

Change Application to the object variable that you have assigned it to.

 

[Helpme21]

Can't you just disable Excel's events before opening the workbook? In Excel it would be:

Application.EnableEvents = False

Change Application to the object variable that you have assigned it to.

Thank You! Works Great!