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