Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Overwrite changes dialogue box

After updating Excel 2003, upon closing after making changes and dialagoue
box appears with the option of saving a copy or overwrite changes? Anyone
know how to turn this annoying feature off.


Post your answer or comment

comments powered by Disqus
Hello Guys,

I have created a (password to open) workbook using Excel 2003 SP1 on a
shared network drive which when I try to save by using Ctrl S or
clicking the Save icon gives me an irritating dialog box which asks:

"The file 'filename.xls' may have been changed by another user since
you last saved it. In that case what do you want to do?"

-Save a copy
-Overwrite changes

Please can someone tell me how to deactivate this annoying dialog box
as I have been unsuccesful so far in my efforts

Many thanks in advance

Nick

--
Nicko
------------------------------------------------------------------------
Nicko's Profile: http://www.excelforum.com/member.php...o&userid=29477
View this thread: http://www.excelforum.com/showthread...hreadid=491778

All of a sudden, this dialog box pops up every time I want to save something
in Excel 2002. The box says,

"The file '' may have been changed by another user since you last
saved it. In that case, what do you want to do?

__ Save a Copy
__ Overwrite changes

even though I'm the only user that's changed anything in the past 3 years.
The shared workbook command has not been changed at all, so that can't be the
problem. The settings are the same as the ones I have at home for personal
spreadsheets that don't have this dialog box.

Help!

Thanks,

Tim

All of a sudden, this dialog box pops up every time I want to save something
in Excel 2002. The box says,

"The file '<file name>' may have been changed by another user since you last
saved it. In that case, what do you want to do?

__ Save a Copy
__ Overwrite changes

even though I'm the only user that's changed anything in the past 3 years.
The shared workbook command has not been changed at all, so that can't be the
problem. The settings are the same as the ones I have at home for personal
spreadsheets that don't have this dialog box.

Help!

Thanks,

Tim

Hello Guys,

I have created a (password to open) workbook using Excel 2003 SP1 on a shared network drive which when I try to save by using Ctrl S or clicking the Save icon gives me an irritating dialog box which asks:

"The file 'filename.xls' may have been changed by another user since you last saved it. In that case what do you want to do?"

-Save a copy
-Overwrite changes

Please can someone tell me how to deactivate this annoying dialog box as I have been unsuccesful so far in my efforts

Many thanks in advance

Nick

I would like to know if I can change the font/color of items I a, saving in a
dialogue box. For instance I have a "Save as" box for Purchase orders that
contains more than 100 entries, I would like to be able to make different
colors to differentiate purchases from different states, without creating new
files or boxes. A person who worked for me has some of the purchase orders
saved in blue, where all mine are black. I can't figure out where to go to
make the changes. Any help would be appreciated.
Thanks
--
Rick M

This is something that is always a problem for me. Whenever I'm selecting
macros to run they are _always_, nearly without any exceptions at all,
macros that are found in the current workbook. I'm always having to change
the option of "All Open Workbooks" to "This Workbook" whenever I open the
macro dialogue box. Can we change that (even if it's a reg edit)? Tx. :oD

How do I create a new shortcut icon on the Open Dialogue Box?

When I press Ctrl-O to open a new file, the Dialogue box opens with 5 icons in the left column consisting of History, My Documents, Desktop, Favorites, and Web Folders. I would like to add or change one of the icons to point to c:/files. Any input on how to do this?

Thanks, Christopher

For some reason I have a number of the functions listed twice in the Paste Function dialogue box - one in lower case & one in UPPER case. However, it is only some of the financial functions that are duplicated.
It doesn't cause any problem (that I know of!) but I'm curious as to why this has happened.

I thought it might be caused by an add-in (I have the Analysis Tool-Pak and Analysis Tool-Pak VBA Add-Ins loaded), but nothing changed when I unloaded the Analysis Tool-Pak!

Anyone got any ideas about what has caused this and/or how to fix it?

Thanks

Good morning.

I need to figure out code that will simply change current directory to a set
directory and then show Excel's "Open" Diaglogue box. I am aware that I can
use an open command to open a certain file, but I don't want to do that. I
want a dialogue box and not a file. Any suggestions? Thanks

Cordially,

Good morning.

I am using an Access VBA module to control Excel and I need to figure out
code that can simply change current directory to a set directory and then
show Excel's "Open" Diaglogue box. I am aware that I can use an open command
to open a certain file, but I don't want to do that. I want dialogue box and
not specify a file. Any suggestions? Thanks

Cordially,

Good morning.

I am using an Access VBA module to control Excel and I need to figure out
code that can simply change current directory to a set directory and then
show Excel's "Open" Diaglogue box. I am aware that I can use an open command
to open a certain file, but I don't want to do that. I want dialogue box and
not specify a file. Any suggestions? Thanks

Cordially,

Good morning.

I need to figure out code that will simply change current directory to a set
directory and then show Excel's "Open" Diaglogue box. I am aware that I can
use an open command to open a certain file, but I don't want to do that,
just Excel's Open dialogue box. Any suggestions? Thanks

Cordially,

Hi,

I'd like to have a macro to NOT have excel ask me if I want to replace the
existing file when i save, ie, when I save a file and there's already one in
the folder, I want excel to just overwrite the file without having a dialogue
box asking me if I want to overwrite the existing file. Is it possible?

Regards,
Dolphin

I have put a new Excel workbook together recently and now when I open it, I get a MS Excel dialogue box that tells me that the workbook has links to another workbook and would I like to update changes to the other workbook.
The only links that I am aware of are a couple of links to websites, with this website being one of them. The other is a Natural Gas Utility site.
How do I find what workbook MS Excel is referring to?
Thank you for your help!!

I run a macro in which I close a window and overwrite a file, but I still get the dialogue box that opens and asks if I want to save the first file before I close it and verify that I do want to overwrite a file. Is there a way to just default to a yes answer?

Hi, I am trying to save a file to directory. I want the saveas dialogue box
to pop up with the file name and pathe I specify, but I want the user to be
able to change the path given that it changes on a monthly basis.

With Sheets("MissingSTAvg_Corp")
.SaveAs Filename:= _
"Q:ResultsMarch 06MissingSTAvg_Corp" & InputBox("Please Enter
Date As MM-DD-YY")
End With

The "March 06" will change monthly. Thanks

Hi. I am using the BeforeSave code below to bypass the Excel SaveAs function to help control versioning and to preserve the users' list box choices. The code works fine and does what I need it to.

However, if the user selects "Cancel" on the Save As dialogue box generated by the code, it closes the box and the original Excel Save As dialogue box appears, which if used to save the file, bypasses my controls.

Is there a way to prevent the Excel Save As dialogue box from generating when the user Cancels the Save As function I have in code? Many thanks!!

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Dim strMsg As String
If SaveAsUI = False Then
Call SaveListBox
Exit Sub
End If
    
    strMsg = strMsg & "Make sure you continue to save the RCSA template in its" & vbNewLine
    strMsg = strMsg & "original Excel 97-2003 *.xls format" & vbNewLine
    strMsg = strMsg & "" & vbNewLine
    strMsg = strMsg & "Select NO if prompted to change to an Office 2007 Open XML Format" & vbNewLine
        
    MsgBox strMsg, vbInformation, "RCSA ALERT"
    

FName = Application.GetSaveAsFilename( _
        filefilter:="Excel 97-2003 Workbook (*.xls),*.xls")
    If FName = False Then
        Exit Sub
    End If
Call SaveListBox
    With Application
    .EnableEvents = False
    .DisplayAlerts = False
    ThisWorkbook.SaveAs FName, xlExcel8
    .DisplayAlerts = True
    .EnableEvents = True
    End With
    
    Cancel = True

Call RestoreListBox

End Sub


Hi All,

I have a strange situation which works fine in my Home PC but fails when run's at office.Am using the same version of Office 2007 at both Place.
My workbook consist of a sheet named ("Welcome") which when activated shows a Userform.

Userform consist of a button when pressed opens up SAVE AS dialogue box.....whenever i try to scroll this saveas box it leaves a trail only over the sheet under the Userform (ie) over Welcome sheet.It leaves no effect over the Userform.

I even made Application.ScreenUpdating=true before opening up the SAVEAS dialogue box.
When i checked the same form in my home PC it works perfectly and i could move dialouge box to any position without leaving any trails....

Could anyone say what can cause such scenarios in different PC.

Regards
Ashesh

Hi Guys:

Does anyone know if it is possible to disable the "save the changes" Dialog box that appears as you close a workbook. Also, If I disable it in the one application on exit , will it remain disabled for other workbooks? Also is it possible to Disable a Ctrl / function key command?

Thanks

Gents

I'm using a line of VBA to delete a worksheet. This however causes the confirm deletion dialogue box to appear.

Is there a method to bypass this dialogue box as it is uneccessary in this instance for me t have to consider the deletion.

Regards

Simpo

I couldnt find anything in the search about calling the "Macro Dialogue Box" through a button. Any code you can help with?

I use the following to add a toolbar that hides/unhides columns in my spreadsheet. I need a code so I can use this for any spreadsheet, and the user must enter the row number with the column headers into a Dialogue box and it makes a toolbar accordingly. Here is the code I currently have:

workbook:

	VB:
	
 Workbook_Open() 
    ShowHide 
End Sub 
 
Sub ShowHide() 
    Dim cbarName As String 
    cbarName = "Show/Hide" 
    Dim cbar As CommandBar 
     'Delete bar if it exists.
    On Error Resume Next 
    Application.CommandBars(cbarName).Delete 
    On Error Goto 0 
     'Add bar
    Set cbar = Application.CommandBars.Add(Name:=cbarName) 
    Dim i As Long 
    For i = 2 To 78 
        Dim Ctrl As CommandBarButton 
        Set Ctrl = cbar.Controls.Add(msoControlButton) 
        With Ctrl 
            .Caption = ActiveSheet.Cells(11, i).Value 
            .OnAction = "ButtonToggle" 
            .Style = msoButtonCaption 
            .State = Columns(i).EntireColumn.Hidden 
            .Tag = "0" 
            If .Caption = "" Then 
                .Visible = False 
            End If 
        End With 
    Next i 
    cbar.Visible = True 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Module

	VB:
	
 ButtonToggle() 
    Dim ctlPressed As CommandBarButton 
    Dim i As Long 
    Set ctlPressed = Application.CommandBars.ActionControl 
    With ctlPressed 
        If .State = msoButtonDown Then 
            .State = msoButtonUp 
        Else 
            .State = msoButtonDown 
        End If 
        Dim idx As Long 
        idx = .Index + 1 
        Columns(idx).Hidden = .State 
        idx = idx + 1 
        While Columns(idx).Cells(11).Value = "" And idx < 78 
            Columns(idx).Hidden = .State 
            idx = idx + 1 
        Wend 
    End With 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Hi,

I am trying to get the file dialogue box to load, the user then selects a file, clicks ok and the filepath of the file selected apears in a label on a form.

Any ideas?

Thanks very much,

Jon

Firstly, I should state that my knowledge of the Microsoft Internet Controls and MSHTML libraries is low. I started using them recently to try to automate the downloading of excel reports from a webform. As such, this has been a learning experience, and my code definitely reflects that.

The task:
I have a webform which is all scripted in Java. After initializing the page, a javascript determines what tab to display, etc. The result is that the page requires a generous amount of navigation to get to the input elements and to the export link (My guess is there is a better way for this as well, but that is not in scope for this post). I want to fill in the form, then click the link to export the results to excel.

The problem:
I have been able to fill in the form and get it to fire the export link. I am stuck here.

After I export the report, IE (I am restricted to IE at work...) opens a new window and then an Excel dialogue box opens with options to open, save, or cancel the document sent from the server. The file name of the export is not constant, and I don't know how to get the path of the export to feed to Excel.

I know methods to access the workbook after I open it, but I am stuck on how to actually open the workbook. Any help would be appreciated.

Obviously, posting the URL would be the best way, but it is restricted, so I cannot.

The code:

	VB:
	
 
Sub positionsDownload() 
     
    Dim appIE As InternetExplorer 
    Dim doc1 As HTMLDocument 
    Dim doc2 As IHTMLElementCollection 
    Dim doc3 As IHTMLElementCollection 
    Dim doc4 As HTMLFrameElement 
    Dim doc5 As IHTMLElementCollection 
    Dim doc6 As HTMLFrameElement 
    Dim doc7 As HTMLDocument 
    Dim doc8 As HTMLFormElement 
    Dim doc9 As IHTMLInputElement 
    Dim doc10 As IHTMLTextAreaElement 
    Dim doc11 As HTMLFrameElement 
    Dim doc12 As HTMLDocument 
    Dim doc13 As HTMLLinkElement 
    Dim wbCount As Integer 
    Dim newWb As Integer 
    Dim wsCount As Integer 
    Dim downloadedWb As Workbook 
    Dim userDate As String 
    Dim userCusip As String 
     
    Application.DisplayAlerts = False 
     
     'specify user inputs here: parameterize after the rest of the code is working...
    userDate = "11/30/2011" 
    userCusip = "248019AG6" 
     
    wbCount = Workbooks.Count 
    newWb = wbCount + 1 
    wsCount = ThisWorkbook.Sheets.Count 
     
     'setting the URL that has the webform...
    sURL = "https://xxx/search_tools.epl" 
    Set appIE = New InternetExplorer 
     
     'open the webform and display to user
    appIE.Navigate sURL 
    appIE.Visible = True 
     
     'loop until ready
    Do While appIE.Busy 
    Loop 
     
    Do Until appIE.readyState  READYSTATE_COMPLETE 
        DoEvents 
    Loop 
     
     'the JScript does not seem to fire the readystate complete...so wait 10 seconds to be sure
    Application.Wait (Now + TimeValue("00:00:10")) 
     
     'set the location of the input elements
    Set doc1 = appIE.document 
    Set doc2 = doc1.getElementsByTagName("form") 
    Set doc3 = doc1.all 
    Set doc4 = doc3.Item("tool_frame") 
    Set doc5 = doc4.contentDocument.all 
    Set doc6 = doc5.Item("content_frame") 
    Set doc7 = doc6.contentDocument 
    Set doc8 = doc7.forms(, 1) 
     
     'find the pos date and update to be the user specified date
    For Each doc9 In doc8.getElementsByTagName("INPUT") 
        If InStr(doc9.Name, "pos_date") Then 
            doc9.Value = userDate 
            Exit For 
        End If 
    Next doc9 
     
     'find the altid and update to be the user specified CUSIP
    For Each doc10 In doc8.getElementsByTagName("TEXTAREA") 
        If InStr(doc10.Name, "altid") Then 
            doc10.Value = userCusip 
            Exit For 
        End If 
    Next doc10 
     
     'set the path for the export link
    Set doc11 = doc5.Item("header_frame") 
    Set doc12 = doc11.contentDocument 
     
     'find the export link via the outerHTML word export
    For Each doc13 In doc12.Links 
        If InStr(doc13.outerHTML, "Export") Then 
            doc13.Click 
            Exit For 
        End If 
    Next doc13 
     
     'Application.Wait (Now() + TimeValue("00:00:10"))
     
     'Set downloadedWb = Workbooks(newWb)
     'downloadWb.Sheets(1).Move After:=ThisWorkbook.Sheets(wsCount)
     
    Application.DisplayAlerts = True 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines



No luck finding an answer? You could always try Google.