RE: Problem with the internet transfer control

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: vbphil (vbphil_at_online.nospam)
Date: 01/31/05


Date: Mon, 31 Jan 2005 07:25:04 -0800

Bonj,
I have a similar licensing problem with using the inet control from Excel
VBA code. The code ran fine on my development machine but not on other users.
If I installed VB to a non-working machine the code ran fine. As near as I
can tell certain probucts like VB and Office Development install the ocx
license. The documentation is very sparse. You might try installing VB on
your server and see what happens.

I'd also like to know how to deploy this ocx so that it works from Excel
without any other developer products installed on the user's machine?

-phil

"Bonj" wrote:

> Hi
> I am creating a project that needs to get the title of a bunch of web pages.
> e.g., I have the string "http:// intranet / webapp1 / thepage.asp"
> I need to send that request off to the web server, get the html back, parse
> the "<title>TheTitle</title>" out using a regex, and retrieve the "TheTitle"
> as my answer.
>
> Aswell as the title, I also need to get the page's creation date, so the
> process needs to run on the web server - in order that it can access the
> actual asp file. This means that my VB program that is retrieving these two
> pieces of information needs to run on the web server itself. The other
> reason it needs to run on the web server itself is that it is a nightly job
> and a PC that gets switched off at night wouldn't be reliable enough.
>
> I've tested the function that gets the title on my own machine, and it works
> fine. This is via a hidden form with the internet transfer control ocx on
> it. However, when I run it on the web server (a windows 2000 advanced
> server) I get the error " class does not support automation or expected
> interface ". I get this no matter whether I regsvr32 the .ocx for the
> internet transfer control manually, or with the P&D W.
>
> If I try and do createobject("inetctls.inet") from a .vbs, I get a license
> error.
>
> Has anyone got any suggestions as to what might be up with the Inet on
> theweb server?
>
>
>



Relevant Pages

  • Re: xcel error at web server
    ... > We don't want to install Excel at the web server. ... One other approach is to use the Microsoft Office Web Components and embed ... The clients that run the page will need to download and install the ... > I have Excel 2000 install at my workstation, but not at the web server. ...
    (microsoft.public.dotnet.framework)
  • xcel error at web server
    ... I have Excel 2000 install at my workstation, but not at the web server. ... Excel.Application EXL; ...
    (microsoft.public.dotnet.framework)
  • Deploy to web server ( soft-sys )
    ... I would like to run my script on a web server that I do not have root ... access with (i.e. cannot install anything). ... This appears to me to be potentially against the license terms. ...
    (comp.soft-sys.matlab)
  • Re: Hardening a Solaris system.
    ... > I've set up a web server, running Apache, so are thinking about what I ... If there is a point in getting the hardware firewall to forward data ... ADSL in, USB out, and two ethernet connections. ... Apache is the standard Solaris install, with a few changes to the ...
    (comp.unix.solaris)
  • Re: Hardening a Solaris system.
    ... > I've set up a web server, running Apache, so are thinking about what I ... If there is a point in getting the hardware firewall to forward data ... ADSL in, USB out, and two ethernet connections. ... Apache is the standard Solaris install, with a few changes to the ...
    (comp.security.unix)