Using VBscript to change an Excel spreadsheet without Excel Application

Hi,

I have created a VBscript to format an Excel spreadsheet, but when I go
to execute it on the server that has the database from which the data
is extracted, I get an error as the server does not have Excel
installed on it.

Is there ANY way to get around this without having to install Excel,
inventive answers are more than welcome.

TIA

Chris aka BoobBoo

Harlan
Fri Dec 30 22:09:33 CST 2005

<chris.kernaghan@gmail.com> wrote...
>I have created a VBscript to format an Excel spreadsheet, but when I go
>to execute it on the server that has the database from which the data
>is extracted, I get an error as the server does not have Excel
>installed on it.
>
>Is there ANY way to get around this without having to install Excel,
>inventive answers are more than welcome.

Maybe not using VBScript. There are Perl modules that can write Excel .XLS
files without using Excel. Good luck translating them to VBScript.

McKirahan
Fri Dec 30 23:40:08 CST 2005

<chris.kernaghan@gmail.com> wrote in message
news:1135995900.210941.96240@g49g2000cwa.googlegroups.com...
> Hi,
>
> I have created a VBscript to format an Excel spreadsheet, but when I go
> to execute it on the server that has the database from which the data
> is extracted, I get an error as the server does not have Excel
> installed on it.
>
> Is there ANY way to get around this without having to install Excel,
> inventive answers are more than welcome.
>
> TIA
>
> Chris aka BoobBoo
>

If the client has MS-Excel installed and the use Internet Explorer and
they'll permit a Security Violation, you could use VBScript on the
client-side. Or look into HTML Application (HTA).

Joe
Sat Dec 31 06:35:45 CST 2005

<chris.kernaghan@gmail.com> wrote in message
news:1135995900.210941.96240@g49g2000cwa.googlegroups.com...
> Hi,
>
> I have created a VBscript to format an Excel spreadsheet, but when I go
> to execute it on the server that has the database from which the data
> is extracted, I get an error as the server does not have Excel
> installed on it.
>
> Is there ANY way to get around this without having to install Excel,
> inventive answers are more than welcome.
>
> TIA
>
> Chris aka BoobBoo
>
With traditional BIFF files (the format used by Excel) you're basically
manipulating a binary file, so in theory it's possible using the
adodb.stream object, but you'd need a very good knowledge of the format.
If you're able to store the files as XML, as used in the the last two
versions of Excel, then it's more feasible as you can maniplulate the DOM or
use XSLT.

--
Joe Fawcett - MVP

https://mvp.support.microsoft.com/profile=8AA9D5F5-E1C2-44C7-BCE8-8741D22D17A5