read and write data Excel workbookg from VB

  • Thread starter Thread starter Jean-Luc CAPEL
  • Start date Start date
J

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
 
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
 
Back
Top