Excel Interaction

[levimefford@gmail.com]

Alright, so I've got a pretty hefty program that is integrating with
excel. My problem is that I'm wanting to avoid a particular dialog
from appearing, just because the portion that it pertains to is
automated. Basically, this has to deal with the .merge function for a
range of cells in excel. It basically asks if I want to continue to
merge the cells since the data from the upper left will be the only
data used. I'm not sure why it asks this, though, considering the
worksheet has no data on it, unless it (for some reason unknown to me)
is trying to apply the changes retrospectively to previously created
worksheets and then overriding that data in my newly created
worksheet.

What I wanna know is how to make it automatically accept those changes.

[Jan Hyde (VB MVP)]

Re: Excel Interaction

"levimefford@gm ail.com" <levimefford@gm ail.com>'s wild
thoughts were released on Tue, 16 Oct 2007 04:56:49 -0000
bearing the following fruit:

>Alright, so I've got a pretty hefty program that is integrating with
>excel. My problem is that I'm wanting to avoid a particular dialog
>from appearing, just because the portion that it pertains to is
>automated. Basically, this has to deal with the .merge function for a
>range of cells in excel. It basically asks if I want to continue to
>merge the cells since the data from the upper left will be the only
>data used. I'm not sure why it asks this, though, considering the
>worksheet has no data on it, unless it (for some reason unknown to me)
>is trying to apply the changes retrospectively to previously created
>worksheets and then overriding that data in my newly created
>worksheet.
>
>What I wanna know is how to make it automatically accept those changes.

Some methods allow you to pass flags that will prevent such
messages, I have no idea if that is the case here.

However you might try looking at the DisplayAlerts property.


--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde

[Rad [Visual C# MVP]]

Re: Excel Interaction

On Tue, 16 Oct 2007 09:29:40 +0100, "Jan Hyde (VB MVP)"
<StellaDrinker@ REMOVE.ME.uboot .comwrote:

>"levimefford@g mail.com" <levimefford@gm ail.com>'s wild
>thoughts were released on Tue, 16 Oct 2007 04:56:49 -0000
>bearing the following fruit:
>

>>Alright, so I've got a pretty hefty program that is integrating with
>>excel. My problem is that I'm wanting to avoid a particular dialog
>>from appearing, just because the portion that it pertains to is
>>automated. Basically, this has to deal with the .merge function for a
>>range of cells in excel. It basically asks if I want to continue to
>>merge the cells since the data from the upper left will be the only
>>data used. I'm not sure why it asks this, though, considering the
>>worksheet has no data on it, unless it (for some reason unknown to me)
>>is trying to apply the changes retrospectively to previously created
>>worksheets and then overriding that data in my newly created
>>worksheet.
>>
>>What I wanna know is how to make it automatically accept those changes.

>
>Some methods allow you to pass flags that will prevent such
>messages, I have no idea if that is the case here.
>
>However you might try looking at the DisplayAlerts property.

You could also try sending keystrokes to the excel instance and see if
you can push the buttons that way

--

http://bytes.thinkersroom.com