ActiveWorkbook.SaveAs
(1)
Workbooks
(1)
Excel
(1)
UpdateLinks
(1)
OpenCat
(1)
Refreshable
(1)
Cmd
(1)

UpdateLinks Popup on Workbooks.Open

Asked By AFSSkier
08-Jan-10 01:41 PM
I have a refreshable Excel 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
do not 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 a temp file on end-user???s PC, leaving original template
as is.
End Sub

--
Thanks, Kevin
Post Question To EggHeadCafe