I'm having trouble turning off the dialog box for user to choose update/edit the links in a Excel workbook using VBA. The codes are written in Access:
The prompt still appears although I set it as update always.
Can anyone help?
Dim acExcel, wb
xlPath = "F:\xxxxxx"
Set acExcel = CreateObject("Excel.Application")
acExcel.Visible = True
Set wb = acExcel.Workbooks.Open(Filename:=xlPath, UpdateLinks:=xlUpdateLinksAlways)
'--------work on the data-------------
Set wb = Nothing
Set acExcel = Nothing