Editing an Excel Worksheet with vb.net

[chris.bunch@gmail.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?

[vbnetdev]

Re: Editing an Excel Worksheet with vb.net

Did you remember to

Application.Dis playAlerts = False

--
Get a powerful web, database, application, and email hosting with KJM
Solutions

http://www.kjmsolutions.com

<chris.bunch@gm ail.com> wrote in message
news:1145041483 .101621.109480@ e56g2000cwe.goo glegroups.com.. .[color=blue]
>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?
>[/color]