R
Roger R
Last friday I asked the question of how to write VBA that
will make the "Update links" prompt appear when opening a
linked file. I recieved feed back that showed me how:
Workbooks.Open Filename:="c:\test.xls", UpdateLinks:=0
Which works wonderfully, except I must have asked the
question wrong, because I want not only the promt to not
come up, but I DO NOT want the links to be updated. Is
there any way to do this? Also I was directed to "Help on
Update Link Properties" Is this the help in VBA? or on MS
website tutorials, I was confused as to which Help to go
to.
will make the "Update links" prompt appear when opening a
linked file. I recieved feed back that showed me how:
Workbooks.Open Filename:="c:\test.xls", UpdateLinks:=0
Which works wonderfully, except I must have asked the
question wrong, because I want not only the promt to not
come up, but I DO NOT want the links to be updated. Is
there any way to do this? Also I was directed to "Help on
Update Link Properties" Is this the help in VBA? or on MS
website tutorials, I was confused as to which Help to go
to.