ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   access excel control from vb.net (https://www.excelbanter.com/excel-programming/349509-access-excel-control-vbulletin-net.html)

direland

access excel control from vb.net
 
I am opening a web page in excel using vb.net and there are HTML controls
imbedded in the sheet (checkboxes). I need to access the value of these
controls in code. Can anyone give me a hand? Code below...

Dim appMPO As New Excel.Application
Dim wrkMPO As Excel.Workbook
Dim shtMPO As Excel.Worksheet

wrkMPO = appMPO.Workbooks.Open("http://*****")
shtMPO = wrkMPO.Worksheets(1)

'Need to access the Value property of control called HTMLCheckbox1 on
Sheet1????


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com