I have read many articles and they all say what I am doing should work. It doesn't.
The code brings up intelesence while entering. I t compiles without error but crashes when running.
I have tried "setwarnings". It doesn't crash but also has no effect on the excel alerts.
I can successfully open the required excel file after passing the alert so feel all the relevant references have been ticked.
Any suggestions
Code:
Private Sub btnOpenFile_Click()
Excel.Application.DisplayAlerts = False
' DoCmd.SetWarnings False
Application.FollowHyperlink Me.txtFileName, True
' DoCmd.SetWarnings True
Excel.Application.DisplayAlerts = True
End Sub
The code brings up intelesence while entering. I t compiles without error but crashes when running.
I have tried "setwarnings". It doesn't crash but also has no effect on the excel alerts.
I can successfully open the required excel file after passing the alert so feel all the relevant references have been ticked.
Any suggestions