I have a routine that loops and creates (Saves) a .pdf file with each loop. I have chosen to open each .pdf file as it gets created.
During the loop phase a Msgbox may popup if there is an exception with data in the file. The problem is the excel Window & new popup are hidden behind the previously opened .pdf file windows. Is there a command I can have just prior to the Msgbox code section that will bring the Excel window & popup to the forefront?
I've tried the following, but it doesn't work:
During the loop phase a Msgbox may popup if there is an exception with data in the file. The problem is the excel Window & new popup are hidden behind the previously opened .pdf file windows. Is there a command I can have just prior to the Msgbox code section that will bring the Excel window & popup to the forefront?
I've tried the following, but it doesn't work:
Code:
Application.WindowState = xlMaximized
Msgbox "............."