Bringing Inputbox into focus

[djcamo]

Hello,

I have some code that takes data from bookmarks in a Word doc and
exports them into an Excel spreadsheet. If one bit of data already
exists in the spreadsheet I flag this and ask the user to enter
another value using an inputbox. The problem is that this inputbox
appears behind the Word doc rather than in front. All the ways I know
of bringing a window into focus do not work given that all code stops
until the inputbox's ok button is pressed. Is there any other way of
bringing the inputbox to the foreground, or for that matter a form
(even here i have had the same issue)

Regards
David

 

[NOPIK]

another value using an inputbox. The problem is that this inputbox

appears behind the Word doc rather than in front. All the ways I know

This is usually result of the Excel process running if foreground. Use
YourWord.Application.Activate

 

[NOPIK]

Oops!
Before input!