LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 85
Default Oddity when opening templates from code

I have some code to open 2 templates and copy some data from one to the
other. The problem I have is that one opens (template-x.xlt) whereas the
other creates a new xls based on the template (template-y1.xls).

I've posted the code segments below:

---
Sub CheckVersion(sTPPath, sUpdRoot, sVer)
With Application
.EnableEvents = False
.Workbooks.Open Filename:= _
sTPPath & "\" & sUpdRoot & ".xlt", _
UpdateLinks:=0
---
sTPPath is C:\Documents and Settings\ianc\My Documents\Template Prep
sUpdRoot is II checklist
This one opens the template file.

---
Sub OpenUpdate(sCurPath, sUpdRoot, sUpdFile)
With Application
.EnableEvents = False
sUpdFile = Dir(sCurPath & "\" & sUpdRoot & "*.xlt")
.Workbooks.Open Filename:= _
sCurPath & "\" & sUpdFile, _
UpdateLinks:=0 ' ===== Retrieve filename from sUpdFile =====
---
sCurPath is C:\Documents and Settings\...............\Remote update (long
path cut)
sUpdFile is II checklist 6.0.2 update.xlt
This one opens an xls file.

I've tried hardcoding the path & filename for the second one. I've also
tried removing the code for the first one in case it's something to do with
it being the second one open, but it still does the same.

This is driving me nuts!

Any ideas?

Ian


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
saved templates opening as templates 4n6DNA Excel Discussion (Misc queries) 2 August 31st 09 09:30 PM
Templates not opening up as workbooks LAM Excel Worksheet Functions 0 March 27th 07 11:29 PM
Inactive User - Code Oddity (actually bizarre) Mike The Newb Excel Discussion (Misc queries) 0 September 1st 06 02:44 PM
Opening Templates greppinfunk[_2_] Excel Programming 0 August 7th 06 03:47 PM
Excel is opening templates as templates instead of as worksheets Desram Setting up and Configuration of Excel 1 January 19th 06 09:38 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"