I'm trying to set cell values in Excel from within my VB program. If that is possible, how can I do it?
Any help would be much appreciated.
Thank you
Printable View
I'm trying to set cell values in Excel from within my VB program. If that is possible, how can I do it?
Any help would be much appreciated.
Thank you
First create a reference to the Excel Object Library
Then in your code create the object
Now you can use the object browser to find out all about the properties / methods etc. available through the excel object.Code:Dim xlsApp As New Excel.Application
Regards