I'm using VS2005 C# to open a workbook invisible, import data from various
worksheets, process some data, then write back to the workbook. My problem is
that when I open the workbook in non-readonly mode, it errors when I try to
write to a cell. I made the workbook visible so I can see what's going on,
and it pops up a dialog with a button to Choose Read/Write for Editing. If I
click the button, my app works fine.
When I open the workbook I set the ReadOnly parm to false, the
IgnoreReadOnlyRecommended parm to true, and the Editable parm to true. I've
also set the Excel.DisplayAlerts to false:

Excel.Workbook obWb = obWorkBooks.Open(filePath, System.Type.Missing,
bReadOnly, System.Type.Missing, System.Type.Missing, System.Type.Missing,
true, System.Type.Missing, System.Type.Missing, !bReadOnly,
System.Type.Missing, System.Type.Missing, System.Type.Missing,
System.Type.Missing, System.Type.Missing);

So what else do I need to do to get this to open as editable with no user
interaction (i.e., with the workbook not visible)?

--
Scott B

Anybody have some input on this? I really need to fix it.
--
Scott B


"Scott B" wrote:

> I'm using VS2005 C# to open a workbook invisible, import data from various
> worksheets, process some data, then write back to the workbook. My problem is
> that when I open the workbook in non-readonly mode, it errors when I try to
> write to a cell. I made the workbook visible so I can see what's going on,
> and it pops up a dialog with a button to Choose Read/Write for Editing. If I
> click the button, my app works fine.
> When I open the workbook I set the ReadOnly parm to false, the
> IgnoreReadOnlyRecommended parm to true, and the Editable parm to true. I've
> also set the Excel.DisplayAlerts to false:
>
> Excel.Workbook obWb = obWorkBooks.Open(filePath, System.Type.Missing,
> bReadOnly, System.Type.Missing, System.Type.Missing, System.Type.Missing,
> true, System.Type.Missing, System.Type.Missing, !bReadOnly,
> System.Type.Missing, System.Type.Missing, System.Type.Missing,
> System.Type.Missing, System.Type.Missing);
>
> So what else do I need to do to get this to open as editable with no user
> interaction (i.e., with the workbook not visible)?
>
> --
> Scott B