A
AFSSkier
I have a refreshable Excel template file that is linked to data imported from
Access.
When I open the file using a Macro button with a Workbooks.Open sub, I get
an Update Links popup.
But, when I open the file directly from the network folder or shortcut, I
don't get the Update Links popup.
I have a temporary Workaround with an UpdateLinks:=False. But I would like
to resolve the issue without a bandaid.
Sub OpenCat()
Workbooks.Open "\\Network_Path\Category_template.xlsx", UpdateLinks:=False
'UpdateLinks:=False cmd is like clicking CONTINUE to leave links as
is.
ActiveWorkbook.SaveAs Filename:="C:\WINDOWS\Temp\Category.xlsx"
'This saves the temp file on End-user’s PC, leaving original
template as is.
End Sub
Access.
When I open the file using a Macro button with a Workbooks.Open sub, I get
an Update Links popup.
But, when I open the file directly from the network folder or shortcut, I
don't get the Update Links popup.
I have a temporary Workaround with an UpdateLinks:=False. But I would like
to resolve the issue without a bandaid.
Sub OpenCat()
Workbooks.Open "\\Network_Path\Category_template.xlsx", UpdateLinks:=False
'UpdateLinks:=False cmd is like clicking CONTINUE to leave links as
is.
ActiveWorkbook.SaveAs Filename:="C:\WINDOWS\Temp\Category.xlsx"
'This saves the temp file on End-user’s PC, leaving original
template as is.
End Sub