Editing an Excel Worksheet with vb.net

[chris.bunch]

I have written code to open an excel workbook and edit 2 worksheets.
The code works great opening and editing a general workbook, but,
though it opens it fine, it will not edit the worsheets in the specific
workbook I need to edit. Though it has this problem it never throws
any kind of exception, just completes like it worked fine.

The only difference with the workbook I need to edit is that it
contains macros. When I open the file, I get the "Enable Macros?"
dialog box. I am thinking that this dialog box is in the way when my
ap tries to edit the worksheets.

I have no idea how to get past this and I am at my wit's end. Any
ideas?

[Homer J Simpson]

<ch*********@gmail.com> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...

I have written code to open an excel workbook and edit 2 worksheets.
The code works great opening and editing a general workbook, but,
though it opens it fine, it will not edit the worsheets in the specific
workbook I need to edit. Though it has this problem it never throws
any kind of exception, just completes like it worked fine.

The only difference with the workbook I need to edit is that it
contains macros. When I open the file, I get the "Enable Macros?"
dialog box. I am thinking that this dialog box is in the way when my
ap tries to edit the worksheets.

I have no idea how to get past this and I am at my wit's end. Any
ideas?

Turn off Excel security Tools:Macros:Security:Low

[chris.bunch]

Turns out the problem was not the macro window. The real problem is
kinda embarassing. I was trying to add the data to an Excel file that
had been created by a consultant. He had hidden the first 20
worksheets in the workbook. I used the name insted of the index for
the worksheet, and it works fine now. Thanks for you help though.