M
Michael
Hi!
I've also posted this question on the Access/Internet group....
I have an access module with some code that attempts to have internet
explorer open a specific url and save the contents to an .xml file. I have
it all working when I step through the code line by line in the debugger, but
it generates an error message on the saveas command when I let it run w/ no
breakpoints.
The specific line of code is:
web.ExecWB OLECMDID_SAVEAS, OLECMDEXECOPT_DONTPROMPTUSER, "C:\test.XML", ""
(note, that is all on one line in my editor. web is the object name I've
assigned)
The error box that pops up says:
"Method 'ExecWB' of object 'IWebBrowser2' failed"
I've tried to slow things down by putting in some loops that trap for the
busy event to clear, (ie. while web.busy debug.print "waiting") but this
makes no difference.
Anyone have any suggestion?
Thanks so much!
-Michael
I've also posted this question on the Access/Internet group....
I have an access module with some code that attempts to have internet
explorer open a specific url and save the contents to an .xml file. I have
it all working when I step through the code line by line in the debugger, but
it generates an error message on the saveas command when I let it run w/ no
breakpoints.
The specific line of code is:
web.ExecWB OLECMDID_SAVEAS, OLECMDEXECOPT_DONTPROMPTUSER, "C:\test.XML", ""
(note, that is all on one line in my editor. web is the object name I've
assigned)
The error box that pops up says:
"Method 'ExecWB' of object 'IWebBrowser2' failed"
I've tried to slow things down by putting in some loops that trap for the
busy event to clear, (ie. while web.busy debug.print "waiting") but this
makes no difference.
Anyone have any suggestion?
Thanks so much!
-Michael