Instantiating Excel Spreadsheets to Edit Checkboxes in C#

N

nautic20

Hi,
I have made an Excel workbook and spreadsheet in VS.NET 2005 using the Excel
Workbook within Visual Studio installed templates. In the spreadsheet I
created, I added checkboxes. Now, I've developed another Windows Form project
in .NET that references the spreadsheet dll so that it may be displayed it to
a user.

I'd simply like to know how to make an instance of the spreadsheet I've made
in .NET within the other windows form project so that I may edit the
checkboxes on the spreadsheet.

I've tried using the 'new' operator to instantiate the spreadsheet, but I
keep getting an error reading: No overload for method
'worksheet1' takes '0' arguments.

I've been able to open the workbook and spreadsheet using
Application.Workbooks.Open(
"C:\\YourPath\\Yourworkbook.xls",
missing, missing, missing, missing,
missing, missing, missing, missing,
missing, missing, missing, missing,
missing, missing);

However, in doing this method, I am unable to access the checkboxes on the
spreadsheet itself. What would be the simplest way to access the checkboxes
and edit them?

Thanks for any help
 

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

Similar Threads

Need Help with Macro Security 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
A very peculiar One Note problem 1
Dumb question alert! What program to use? 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Finding the height of a row in a word table from Excel 0
Menu Macro Not Executing - Need Help 1
how do I find all the rows containing a specific value in excel 1

Top