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 ;-)
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".
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