I have a workbook and I have set up VBA code to save the workbook as
different workbook.

All is working fine except when I open the new workbook I get asked i
I want to update the links to the old workbook.

I want to break this link when I write my new workbook so I set th
save code to be:

With newBook
.UpdateRemoteReferences = False
.SaveLinkValues = False
.SaveAs Filename:=strFileName
.Close
End With

Trouble is this doesn't seem to work. My new workbook still has th
Update Remote References option set on when I open the new workbook an
I get asked if I want to update the references.

I want to save the book without the links being active.

What am I doing wrong?

Thanks in advance

Ro

--
rothc
-----------------------------------------------------------------------
rothco's Profile: http://www.excelforum.com/member.php...fo&userid=3149
View this thread: http://www.excelforum.com/showthread.php?threadid=51170