macro = open xlt as xls 1

[jewel]

hey all

I want to set a button for users to open an xlt as an xls -

this is my macro so far

Sub saveas1()
'
' saveas1 Macro
' Macro recorded 17/05/2004 by Dianne Dalton
'

Workbooks.Add Template:="H:\Word\Template\Tape.xlt"
Windows("comp list maker.xls").Activate
Workbooks("comp list maker.xls").Close SaveChanges:=True
End Sub

I need to add a line in to automatically say yes to update links. I tried to record it but it didn't seem to write anything in to the code.

my comp list maker is in a different folder to the template so it asks do I want to update links - can I code this in??

cheers
Dianne

 

[PHV]

Try this, before the Close:
Application.AskToUpdateLinks = False

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jewel]

thanks PH - that stopped the message coming up, but it still brought up the explorer window looking for the file - so have decided to put it in the same folder and all works fine!

cheers
Dianne