Results 1 to 6 of 6

Thread: Book1.xls

  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Book1.xls

    When I open a new workbook, Excel opens with a new, blank worksheet called Start.dot.xls. (Start.dot.xls is located in the XLS Startup folder of Office). This is cool.

    Here's my question.

    When I open a previously saved Excel spreadsheet, the spreadsheet opens fine, but behind it is Start.dot.xls.
    Is there a way that when I open a saved spreadsheet, that this extra spreadsheet does not appear behind it?

    Also, How do I get rid of the Visio button on the toolbar?

    Thank you for reading this !!

    Michael

  2. #2
    New Lounger
    Join Date
    Dec 2002
    Location
    Dumfries, Virginia, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book1.xls

    Michael,

    I used the online help for this one. Hope it helps.

    Create a sheet template for new worksheets
    Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type.


    On the File menu, click Save As.
    Show Me

    In the Save as type box, click Template (*.xlt).


    In the Save in box, select the folder where you want to store the template.
    To create the default worksheet template, select either the XLStart folder or the alternate startup folder. The XLStart folder is usually
    CsProfilesuser_nameApplication DataMicrosoftExcelXLStart
    where os is the operating system folder

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book1.xls

    You can Hide the Start.dot.xls workbook so that it does not show. To do this, go to the XLStart directory and move the Start.dot.xls file into some other directory (not a subdirectory of XLStart). Open Start.dot.xls in this directory. Click on the Window menu and select Hide. Select Save from the File menu. Move the file back to the XLStart directory. Now, the file should open every time you start Excel, but it should not be visible.

    To get rid of the Visio button on the toolbar, right click on the toolbar and select customize. Drag the Visio button off the toolbar and drop it on the Customize dialog box. Click the Close button to close the dialog box. The button should be gone.
    Legare Coleman

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book1.xls

    Thanks a lot!!
    I can't wait to get back to work and try these remedies.

    Thank you very much for your help.
    Michael

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book1.xls

    OK - I have the template in the xls start folder.
    When I click on Progams/Excel or the Excel shortcut, this workbook is the default.
    Wonderful !! Thanks!!

    Now here is a question.
    Let's say I am in Access and want to send the results of a query to Excel.
    I would select Tools/Office Links/Analyze in Excel.
    How would I be able to have the results put into the Excel Template? (The template has
    headers,footers,etc) Is this even possible?

    Legare:
    Thanks for the tips -it worked fine!!

    Michael

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Book1.xls

    I think you'll have to copy the information from the exported workbook into a new workbook based on the template - AFAIK, Access sets the format for exports to Excel itself, ignoring default Excel templates. Or you can select all records of the query, copy them to the clipboard and paste them into a workbook based on the template.

    Both methods can be automated if necessary. You would need to open an instance of Excel from Access in code - do a search for Excel.Application in the Access forum if you want to know how to do that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •