read and write data Excel workbookg from VB

[Jean-Luc CAPEL]

Hello,

Somebody could it say to me, if there is a possibility to read and write
data in an Excel workbookg from VB (and not VBA) without opening the Excel
application.

In advance, thank you !

Greetings
JL CAPEL

 

[Stephen Land]

Jean-Luc,

If you create an object "Excel.Application" in VB, then define a new object
as the opened filename of interest, you can then manipulate the workbook
object changing cell contents, column widths, fonts, etc. from within VB.
Make sure you release all of your objects when you VB application
terminates.

HTH,
Stephen Land