in reply to Win32::OLE and CGI ?

(Caveat: I don't yet have experience with IIS5.0, so this may be off target.)

I assume that you've already verified the obvious: Excel is installed on the server. A less obvious problem can be one of permission.

By default, IIS 4.0 on NT executes CGIs using a user context that does not have access to all facilities on the server. Instructions for changing that user context to one that does can be found here.

Try that, and see if you get any further.

Replies are listed 'Best First'.
Re: Re: Win32::OLE and CGI ?
by jwherbold (Novice) on Apr 18, 2001 at 02:35 UTC
    Yes Excel is installed on the server, however my goal is to open up excel on the client. What I am trying to do, is use this in conjunction with DBI, and give the user the option to run a report, and bring the data back into Excel for the user.

    I know that I could send back an excel file with another module, but I thought the OLE would be the way to go, and I could learn more this way... there I go thinking again ;-)

    Thanks
    John
[reply]
      Ah. Then what you probably want to is use Spreadsheet::WriteExcel to generate the bits for an Excel file, then send those bits back down the wire to the client with a Content-type of "application/vmd.ms-excel".

[reply]
        Yes this is the other module that I was talking about, and I will take a look at this as well, I was just wanting the power of the OLE (GRAPHS, the ability to swtich to a word file etc) Thanx John
[reply]

In Section Seekers of Perl Wisdom