The high level languages by microsoft have built in libraies to handle all
the functions. The compiled VBA by microsoft is almost identical to the VBA
in excel.

"jaf" wrote:

Hi Jay,
The Excel file format is very complex. The are some tools available to
read/write in Excel format. (AKA "biff" format)

Maybe an obvious solution would be to open the file from another computer
which has Excel installed.
Excel doesn't care where the file is as long as you can navigate to it.

John




"Jay" wrote in message
...
Joel,

Thank you for the response. No I do not have the option of genereting CSV
files. Do you have any idea if it is possible to do what I am asking?
(Modify
an excel spreadsheet without openning excel)

"Joel" wrote:

Can the file be generated as a CSV file? There is no formating in CSV
put it
is a text file that can be used by excel and modified like any other text
file.

"Jay" wrote:

I have a requirement to modify a generated excel file that is generated
by a
reporting tool. My point of entry to the flow is a DLL and since this
is a
production server they will prefer if I do this without installing
excel in
the server. Is this even possible? If yes, could you point me in the
right
direction? I was reading about XLLs but it seems that this is not their
intended use.

Thanks in advance

Jay