Bypassing Update Message

MacroAlan

New Member
Joined
Aug 30, 2004
Messages
31
My app is opening an Excel file, copying one worksheet to my new workbook and closing it. The problem is that someone in their infinite wisdom linked a file that was on their desktop and left the company.

When the file opens it asks the question about Updating. Can I bypass this question all together; or send do not update instructions.

Code:
Set XLap = CreateObject("Excel.Application")
    XLap.DisplayAlerts = False         [COLOR="#B22222"]'TRYING here to ignore the message[/COLOR]
    Set Wb1 = XLap.Workbooks.Open(FilePath & Me.cboCurrent.Text)
    Set WS1 = Wb1.Worksheets(1)
    
    XLap.Visible = True
    XLap.ScreenUpdating = True
    
    Wb1.Activate
    WS1.Activate
    With WS1
        lRow = .Range("Y65000").End(xlUp).Row
I am trying to get the users to un-link the offending file but they “don't get it.”

Thanks
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,089,674
Messages
5,409,655
Members
403,274
Latest member
Lewis1995

This Week's Hot Topics

Top