LizzJ
asked on
Turn off update links using VBA
Hi Experts,
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?
Thanks.
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?
Thanks.
Dim acExcel, wb
Dim xlPath
xlPath = "F:\xxxxxx"
Set acExcel = CreateObject("Excel.Application")
acExcel.Visible = True
Set wb = acExcel.Workbooks.Open(Filename:=xlPath, UpdateLinks:=xlUpdateLinksAlways)
With wb.worksheets("Sheet1")
'--------work on the data-------------
End With
wb.Close False
Set wb = Nothing
acExcel.Quit
Set acExcel = Nothing
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just checking - I presume you want to update links, but kill the message box?
ASKER
Thank you all. But Dave's solution works.
Try using the constant 3 instead of xlUpdateLinksAlways
Regards,
Chris