maybe:
Set mysavedcopy = workbooks.open(filename:=myfilename, updatelinks:=0)
Does myfilename include the path?
SteveC wrote:
Hello Dave and all,
UpdateLinks Issue:
Set mySavedCopy = Workbooks.Open("C:\Documents and Settings\My Documents\Steve\Formatted.xls", 0)
That is, in all the permutations I use trying to keep it close to your original
Set mySavedCopy = Workbooks.Open(FileName:=myFileName)
I get errors.
The following two return Run time errors 1004. These are the only permutations that dont turn €śred€ť in the module as I write them.
Set mySavedCopy = Workbooks.Open("FileName:=myFileName", 0)
Set mySavedCopy = Workbooks.Open("(FileName:=myFileName)", 0)
Is there a solution that will let me keep €śFileName:=myFileName€ť nomenclature to prevent update of links?
--
Dave Peterson