Ignore above post. I am using Automation to open a spreadsheet from word, the spreadsheet loads a form, the form was showing in the Excel window but didn't pop up in front of the VBA editor. I now realise that the only reason it didn't pop up on top is because i was stepping through the code in the VBA editor which was keeping the window active.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.