How to access controls (like: checkbox) in excel

Joined
Dec 16, 2005
Messages
1
Reaction score
0
i am working on a web base project, using technology ASP.Net
i need to access some controls like check boxes and drop down lists on an excel sheet to change their values.

can anybody of u GURUs help me to sort out this problem.

any idea or solution????????

i am using a code below:

Dim xl As New Excel.Application

Dim wb As Excel.Workbook

Dim sh As Excel.Worksheet


wb = xl.Workbooks.Open("c:\asim.xls")
wb.SaveCopyAs("c:\asim2.xls")

wb.Close()

wb = xl.Workbooks.Open("c:\asim2.xls")

sh = wb.Worksheets("Sheet1")

sh.Cells(5, 2) = "Project 1"

sh.Cells(6, 2) = "asim jamil"

sh.Cells(7, 2) = "Hello world"

wb.Save()

wb.Close()

xl.Application.Quit()

 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top