ramasterre
Active Member
- Joined
- Oct 5, 2004
- Messages
- 253
I have a macro that opens up various documents based on input in a userform. the macro looks up the document name and if it cannot find it then an error message pops up telling the user to try again. BUT even when the document is found the error message still pops up. I figured out that it is because there is that pesky "this workbook has information linked to another...blah blah blah...would you like to update?" message. Well, no, i would not like to update. I tried disabling the message but, it still triggers my error message to run. Is there a way to disable the update message or to modify my code to ignore it?
Code:
Workbooks.Open FileName:="S:\EVERYONE\Legal Entity\KSmith\Fed Reporting\FR2900" & "\" & x & "\" & MMM & "\" & "FR2900" & " " & mon & "-" & da
'Here is where the file will open and show the update message
Application.DisplayAlerts = False
uView2900.Hide
Unload uView2900 'this is just the message box
Application.DisplayAlerts = True
If Error Then GoTo msgbox2
msgbox2:
MsgBox "The Fr2900 for the date entered cannot be found. Dates must be in mm/dd/yyyy format", vbAbortRetry = vbAbortRetryIgnore, "Date Not Found"