VBA for Excel, How do I use Workbooks.Add?

[newboy18]

Hi, My routine creates a new workbook from a template
that contains links but I don't want to update the Links
yet.
So I use the line
Workbooks.Add templateStr
This works fine but every time it runs asks if I want to
update the Links.
Is it possible to amend the line so that it does not
update the Links and does not ask the question?

 

[SkipVought]

newboy18,

Can't with the Add method. However, with the Open method you can specify

UpdateLinks  Optional Variant. Specifies the way links in the file are updated. If this argument is omitted, the user is prompted to specify how links will be updated. Otherwise, this argument is one of the values listed in the following table.

Value Meaning 
0 Doesn't update any references 
1 Updates external references but not remote references 
2 Updates remote references but not external references 
3 Updates both remote and external references

Hope this helps


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com