I have this project that I need to automate opening of IE(64bit) in MS Access 2010(64bit) vba.
I have no problem automating ie in a 32bit environment but not on 64bit. Has anyone ever have this requirement? I would love to know how did you do it.
setup: - windows 7 64 bit - MS Access 2010 64 bit - ie 64 bi开发者_开发百科t
Are you sure you're running the 64bit browser?
The default browser on 64bit Windows 7 is the 32 bit browser (because most 3rd party plugins are 32bit).
There should be a link somewhere for Internet explorer 64bit (if you type Internet explorer 64bit into the start prompt you'll find it).
Use the FollowHyperlink method: http://msdn.microsoft.com/en-us/library/bb237946(v=office.12).aspx
Or otherwise you can use ShellExecuteEx
精彩评论