Hello
I am writing reports in html from my VBA program. Typically I use a statement like:
myvalue1 = Shell("C:\Program Files\Internet Explorer\IEXPLORE.exe c:\BarCheckReport.htm", 1)
to open the report in windows internet explorer. My question is, is it possible to detect if IE is already opened, and if so, to replace the report that is being shown in IE with the same file name. The goal is to prevent having to close IE each time a new report is generated by the program.
Thank you
John