473,573 Members | 3,123 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to remove the message



hi...

need some expert help. i am open an excel file with a simple link as "<a
="file:///c:/inetpub/wwwroot/test.xls">"

no problem with this.
it opens in the same window (same explorer window) as my asp form is.
This is what i want so this is not the problem!
What happens is that when i open the excel workbook i have some data
being retrieved from the database and later when the user inputs some
values inside it and clicks button "SAVE" inside it i will save it in
the database directly thru vba code.

when i simply click the link and open the workbook and i click back
button it gives an informative message as:
"the document has been modified.Do u want to save the changes
yes: save your changes
no: discard your changes
cancel: keep this document open.

i simple want to supress this error message?? how can i do that?
i am using asp as the web langeuage

thanks a lot

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 22 '05 #1
3 1173
"VbUser25" <mo************ **@YAHOO.com> wrote in message
news:uS******** *****@TK2MSFTNG P11.phx.gbl...


hi...

need some expert help. i am open an excel file with a simple link as "<a
="file:///c:/inetpub/wwwroot/test.xls">"

no problem with this.
it opens in the same window (same explorer window) as my asp form is.
This is what i want so this is not the problem!
What happens is that when i open the excel workbook i have some data
being retrieved from the database and later when the user inputs some
values inside it and clicks button "SAVE" inside it i will save it in
the database directly thru vba code.

when i simply click the link and open the workbook and i click back
button it gives an informative message as:
"the document has been modified.Do u want to save the changes
yes: save your changes
no: discard your changes
cancel: keep this document open.

i simple want to supress this error message?? how can i do that?
i am using asp as the web langeuage


Why are you using "file:///c:/inetpub/wwwroot/test.xls" Shouldn't it be
"http://yourserver/test.xls"?
Jul 22 '05 #2
You will need to mark the document as "unmodified " in your VBA code after
you update the database. Check the documentation for the excel automation
objects or ask on an excel newsgroup.

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"VbUser25" <mo************ **@YAHOO.com> wrote in message
news:uS******** *****@TK2MSFTNG P11.phx.gbl...


hi...

need some expert help. i am open an excel file with a simple link as "<a
="file:///c:/inetpub/wwwroot/test.xls">"

no problem with this.
it opens in the same window (same explorer window) as my asp form is.
This is what i want so this is not the problem!
What happens is that when i open the excel workbook i have some data
being retrieved from the database and later when the user inputs some
values inside it and clicks button "SAVE" inside it i will save it in
the database directly thru vba code.

when i simply click the link and open the workbook and i click back
button it gives an informative message as:
"the document has been modified.Do u want to save the changes
yes: save your changes
no: discard your changes
cancel: keep this document open.

i simple want to supress this error message?? how can i do that?
i am using asp as the web langeuage

thanks a lot

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 22 '05 #3
i have already asked in the excel group..no help till now.

if u can help explain what u mean by "marking hte document as
unidentified".. it will reallyhelp give me a lead.
thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 22 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
20635
by: Peter Gomis | last post by:
I have encountered a situation where I am unable to remove a .NET assembly from the GAC. The message I receive is "Assembly 'assemblyname' could not be uninstalled because it is required by other applications." Although I have seen this before when trying to remove .NET assemblies that have been installed via an MSI package, I now get this...
12
55539
by: Sam Collett | last post by:
How do I remove an item with a specified value from an array? i.e. array values 1,2,2,5,7,12,15,21 remove 2 from array would return 1,5,7,12,15,21 (12 and 21 are NOT removed, duplicates are also removed) So far I have (val is value, ar is array, returns new array):
4
10390
by: wk6pack | last post by:
Hi, I'm trying to use the remove method on a string but it doesnt seem to change it. name.remove(instr(name," ")-1,1) If name = bon jovi, I would like bonjovi but I get bon jovi in the msgbox to display it. I thought it suppose to remove the character space?
2
24620
by: MFRASER | last post by:
How do I go about looping through a hash table and removing items. I know how do this in a collectionbase, but can't iterate through the hash table with out getting an error. Here is my sample code for a collection base for(int i = this.Values.Count; i > 0 ; i--) { //Set local object
3
3795
by: Don | last post by:
My user control has a combobox with an arraylist attached to it along with custom add and remove methods. The "Add" method is working great. However I don't understand why the "Remove" method isn't working. It neither removes the item from the arraylist nor from the combobox like it's supposed to do. A couple of notes: cbx is the name of...
9
20134
by: Charles Law | last post by:
I have a form on which user controls are placed at runtime. When a control is added to the form a handler is added for an event that a high-level object raises, which must be handled by the new control. When I close the form I am expecting that the control ceases to be. However, if my object raises the event after the form has been closed, I...
3
7141
by: Agnes | last post by:
I need to Load 4thousand record into a datagrid for the user to choose. After the user click the row, I will save it. Now, How can I remove the uncheck row. Dim myDelRowArray() As DataRow = dtRvDetail.Select("check = false ") Me.dtRvDetail.Rows.Remove(myDelRowArray) <-- I know there is error, since i cannot delete the datarowarray. Any...
6
7163
by: tshad | last post by:
Is there a reason to use session.remove over session.contents.remove? Don't they both remove the key and data from the contents collection? I assume that session(x) = nothing does essentially the same thing but is actually deleted later by the GC. Thanks, Tom
10
18055
by: =?Utf-8?B?YmJn?= | last post by:
Hi all, I wanted to go through each entry(?) of ArrayList and remove some particular entry. So I tried following but it throws exception at runtime: foreach (myEntry entry in myArrayList) { // do something... if (entry.fieldA == 0)
3
5247
by: Allen Chen [MSFT] | last post by:
Hi Richard, Quote from Richard================================================== However I also want to be able to remove the panes. I have tried to include this, but find that when I first add the pane the remove event does not get handled, though thereafter it is handled without problems....
0
7778
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8017
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8201
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7777
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6413
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5585
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5290
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3731
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3731
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.