automating internet explorer with office XP.

[Fuga]

I´m thinking of starting to use office XP for a small system I have. My question is:

Is office XP more compatible with internet explorer in terms of VBA automating? I have had to work around internet explorer quite a lot in office 97, and I haven´t been able to do what I want.

Fuga.

 

[The_Doc_Man]

Is office XP more compatible with internet explorer in terms of VBA automating?

More compatible than AC97? You betcha. BUT be careful of automating ANYTHING to do with the internet (or the big-I Internet). Security issues abound in web pages everywhere.

Also, you have to be VERY careful in what you are trying to do because you have to remember: IE, like all other browsers, has no continuing context unless the page builders built in such a thing. Normally, all pages are treated as independent, separate data requests no matter how it looks from your end. So be careful about the assumptions you make.

 

[Fuga]

Thanks for your reply.

I see your point. Unfortunately, I´m not very good att internet programming (I tried once to make a connection between an access db and frontpage (supposed to be easy) and I failed, so you get the idea...)

However, if you can download the information manually with the ordinary "save as" command, you should be able to get the same result with "save as" executed with a VBA line, right?

Fuga.

 

[The_Doc_Man]

However, if you can download the information manually with the ordinary "save as" command, you should be able to get the same result with "save as" executed with a VBA line, right?

The operative term is "IF"

I looked on my own system running Win2K and corresponding versions of IE. I can't find VBA in the Help and I also can't find explicit modules that can be added to a References list. Which might mean that I was incorrect about using IE with Office. I must have been looking at something else when I answered you earlier. (Sorry!) You might have to do something less "visual."

 

[Fuga]

Yes, I was afraid of that.

What I do now is I use the "ldownload" function to save the source as a text file. It works ok, but when it comes to some pages that have paswords etc, the "ldownload" function only retrieves data that can be view when not logged in. This is true even if you in fact log in first. However if you manually save the web page when logged in, the correct data is there.

I looked around in microsoft kb, and I found something that might be what I´m looking for, but it requires visual basic.

Thanks anyway!


Fuga.