Excel automation from .net

  • Thread starter Thread starter Erling
  • Start date Start date
E

Erling

I am automating an Excel Spreadsheet from a .net windows
app. I have no problem automating various Excel cells
based upon the following declarations. My question is how
do I open an Excel Form from a .vba.net form, and how do
you " fire" an event on the Excel form (for example "
button click.")


This is how I communicate to Excel targeted cells
from .net

Public objApp As Excel.Application
Public objBook As Excel._Workbook
Public objBooks As Excel.Workbooks
Public objsheets As Excel.Sheets
Public objSheet As Excel._Worksheet
Public objChart As Excel.Chart

'declare the target cells for each procedure.

objsheets = objBook.Worksheets
objSheet = objsheets("Sheet1")

objsheet.Range("a1").Select


Assuming I have a button click event on Excel Form 1 and
Form 2, how would I fire those events from .net

Following up, how do you show/hide the excel same forms,
and close them?

Thanx
 
Back
Top