How do I use Workbook.Add
 

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?

How do I use Workbook.Add
 

Try....

Application.DisplayAlerts = False
Workbooks.Add templateStr
Application DisplayAlerts = True

"Neyboy18" wrote in message
...
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?





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

How do I use Workbook.Add
 

Thanks, but because the default is to Update the links,
wont this do the same?

-----Original Message-----
Try....

Application.DisplayAlerts = False
Workbooks.Add templateStr
Application DisplayAlerts = True

"Neyboy18" wrote
in message
...
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?





----== Posted via Newsfeed.Com - Unlimited-Uncensored-
Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the
World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total
Privacy via Encryption =---
.

How do I use Workbook.Add
 

"Newboy18" wrote in message
...
Thanks, but because the default is to Update the links,
wont this do the same?


Would this help you?

ActiveWorkbook.UpdateRemoteReferences = False

(Insert in code before opening template, then set back to true again
afterwards.)

How do I use Workbook.Add
 

Hi thanks for the ideas but it still asks to Update Links
and the default checkbox is still set to Update Links
This is what I have so far:

ActiveWorkbook.UpdateRemoteReferences = False
Application.DisplayAlerts = False
Workbooks.Add templateStr
Application.DisplayAlerts = True
ActiveWorkbook.UpdateRemoteReferences = True


-----Original Message-----

"Newboy18" wrote
in message
...
Thanks, but because the default is to Update the links,
wont this do the same?


Would this help you?

ActiveWorkbook.UpdateRemoteReferences = False

(Insert in code before opening template, then set back
to true again
afterwards.)




.

How do I use Workbook.Add
 

I don't believe there is a way to avoid this in xl2000 and earlier with a
setting. In xl2002 there is a setting to suppress this query (so you would
set it in the template - it is under the links option in the edit menu as I
recall - but if the workbook were opened in an earlier version, this would
not work).

UpdateRemoteReferences does not affect the question.

The way I would do this is open the template as a workbook, then saveas
using a new name so you don't overwrite your template. When you open the
template, set the updatelinks argument to 0

Workbooks.Open "C:\MyTemplate.xlt", UpdateLinks:=0
ActiveWorkbook.SaveAs "C:\MyTemplate1.xls", Fileformat:=xlWorkbookNormal

--
Regards,
tom Ogilvy




Newboy18 wrote in message
...
Hi thanks for the ideas but it still asks to Update Links
and the default checkbox is still set to Update Links
This is what I have so far:

ActiveWorkbook.UpdateRemoteReferences = False
Application.DisplayAlerts = False
Workbooks.Add templateStr
Application.DisplayAlerts = True
ActiveWorkbook.UpdateRemoteReferences = True


-----Original Message-----

"Newboy18" wrote
in message
...
Thanks, but because the default is to Update the links,
wont this do the same?


Would this help you?

ActiveWorkbook.UpdateRemoteReferences = False

(Insert in code before opening template, then set back
to true again
afterwards.)




.