I have a code which use ActiveX server for Excel.
Under Windows XP, when the script runs to close the spreadsheet, a UI window prompts to front-end, asking me whether to save the spreadsheet.
Recently I switched to Windows 7. When the same script runs to close the spreadsheet, the UI window still comes to ask me whether to save the spreadsheet, but this window always hide at back-end. I always need to minimize other windows in the front-end to show this UI window....very annoying
Anyone know how to fix this? Thanks a lot.