Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Default excel Templates BOOK.xlt Not able to open default excel woorkbook

Latest post Thu, Jun 5 2008 6:32 AM by ssansarwal. 3 replies.
  • Tue, Jun 3 2008 7:53 AM

    • ssansarwal
    • Top 100 Contributor
    • Joined on Tue, Jun 3 2008
    • Posts 3
    • Points 31

    Default excel Templates BOOK.xlt Not able to open default excel woorkbook

     Hi, All

    Please help me out i am using Excel 2003 i want to open default excel file with some settings so for that i have created boo.xlt file in the XLstart folder of excel on path  

    C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\XLSTART

    Its working fine on many systems but on some systems its not working when i open the excel on that system it open excel file with default excel settings not the same as my book.xlt.

    I have just check that book.xlt is there at right path and also when i open the Blank Workbook it open diffrent file with diffrent settings as i know it  should be same as my book.xlt as book.xlt is dafault excel template file. Please suggest why it is showing this behaviour

    Please help me out.

    Thanks in advance.

     

    • Post Points: 21
  • Tue, Jun 3 2008 8:38 AM In reply to

    Re: Default excel Templates BOOK.xlt Not able to open default excel woorkbook

    On those systems, in the VBIDE immediate window, see what

     

    ?Application.StartupPath

     

    returns

    Regards

    Bob

    • Post Points: 36
  • Wed, Jun 4 2008 1:48 AM In reply to

    • ssansarwal
    • Top 100 Contributor
    • Joined on Tue, Jun 3 2008
    • Posts 3
    • Points 31

    Re: Default excel Templates BOOK.xlt Not able to open default excel woorkbook

     Thanks BOb,

    Thanks for your reply.

    On those systems i checked ?Application.StartupPath it is same as the all other systems on which it is working fine and my Boo.xlt file is there in this perticular folder  but the issue is still same not pick this book.xlt as default excel. Please help me out

    waiting for your reply.

    Thanks

    Sandeep

     

     

    • Post Points: 5
  • Thu, Jun 5 2008 6:32 AM In reply to

    • ssansarwal
    • Top 100 Contributor
    • Joined on Tue, Jun 3 2008
    • Posts 3
    • Points 31

    Re: Default excel Templates BOOK.xlt Not able to open default excel woorkbook

     Hi, Bob

    Thanks for your reply

    But On those systems i checked ?Application.StartupPath it is same as the all other systems on which it is working fine and my Boo.xlt file is there in this perticular folder  but the issue is still same not pick this book.xlt as default excel. Please help me out

    Thanks

    Sandeep

    • Post Points: 5
Page 1 of 1 (4 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.