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. 2 1470
"le*********@gmail.com" <le*********@gmail.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
On Tue, 16 Oct 2007 09:29:40 +0100, "Jan Hyde (VB MVP)"
<St***********@REMOVE.ME.uboot.comwrote:
>"le*********@gmail.com" <le*********@gmail.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Kevin T. Ryan |
last post by:
Hi Group -
I have written a "semi-program" in MS Excel related to running a football
pool. I've updated it over the past two years or so, to the point where it
is getting pretty advanced. ...
|
by: Matthew Wieder |
last post by:
I have the following requirements:
Build a stand-alone C# application that asks the user to click in a cell
in an Excel spreadsheet, and then displays the address of that cell in
the C#...
|
by: Mark |
last post by:
I was able to get procedure to work in a VB.Net Windows application, and want
to get it to work within a ASP.Net page. It won't create the instance of
Excel. It blows up on the CreateObject...
|
by: Brandon |
last post by:
Hi all,
I'm currently working on a project where we have a need to expose an
Excel spreadsheet on the web as a webservice that needs to be reliable
and available 24x7x365. I've implemented a...
|
by: sotsigo |
last post by:
Hi there,
I am a quite unexperienced VB user and I am trying to do some simple operations in excel. I am presenting my existing problematic code below.
I am trying to copy/paste a range of...
|
by: =?Utf-8?B?QnJpYW5ESA==?= |
last post by:
Guys
I am working with an excel workbook and have 99% complete however there is
one line that is keeping me from fully automating this proecess.
Code:
Excel.Application excelApp = new...
|
by: Bruce_Stough |
last post by:
I am currently using Control.DoDragDrop to drop a text string into Excel. I
use the following code
DataObject dd = new DataObject();...
|
by: jagguy |
last post by:
Hi,
i cant read in data from excel 97 using vb.net 2003.
I get an exception error .
all i want to do is read in values from excel initially. I want to just test it using msgbox.
Dim XL...
|
by: robertgregson |
last post by:
Using C#, .NET3.5, Visual Studio 2008 and WCF on Windows VISTA SP1, I have written a service, service host (as a C# console application) and a client.
The service uses...
|
by: Peter |
last post by:
VS2008 ans ASP.NET 3.5, Office 2003
What is the best way to run Excel Template from ASP.NET web page were the
Excel is only installed on the client without any ActiveX? If so can someone
point...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |