Im having problems opening this HTML file from ACCESS in code. In an if statement, i have this code:
RetVal = Shell(“c:\Program Files\Internet Explorer\Iexplore.exe”, 1)
AppActivate RetVal, True
SendKeys “%FO”
SendKeys filename
I know that this code wont work because im missing a SendKeys line telling the open form to press enter for example. But that is not the problem, either Explorer opens with my homepage, or Access tries to open a New DB. My SendKeys commands are being directed to the Access window instead of the IE window. If anyone has any ideas about this it would be truly appreciated. Thanks
Justin