Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Templates
Hi, I have a problem with trying to get a template to open from inside a sheet. At the moment I have a large workbook which has lots of data that the template uses for lists boxes and INDEX/MATCH lookups. The problem I've got is I want to allow the user to click a button which will create a template for them from the original sheet (so they only have one sheet to use). Trouble is when I open the template through windows explorer whilst the workbook with all the information is open and I get no errors and all the functionality works fine. However when I try to use VBA to open a template I get the "Update Links" message which no matter what option I press breaks the functionality of the sheet. I've tried; Workbooks.open "sheet1.xlt" and Workbooks.Add Template:="sheet1.xlt" The first one just opens the template for editing and the second gives me the update error I'm trying to avoid, and for some reason I can't seem to add the UpdateLinks:=0 thing either excel just says it's an invalid arguement. Can anyone help? -- greppinfunk ------------------------------------------------------------------------ greppinfunk's Profile: http://www.excelforum.com/member.php...o&userid=37096 View this thread: http://www.excelforum.com/showthread...hreadid=569005 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
saved templates opening as templates | Excel Discussion (Misc queries) | |||
Templates not opening up as workbooks | Excel Worksheet Functions | |||
Excel is opening templates as templates instead of as worksheets | Setting up and Configuration of Excel | |||
excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming |