Results 1 to 6 of 6
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Open more than one sheet on startup (97/XP)

    Hi All

    In my distant memory, I remember a neat little trick where you could have any number of new workbooks open up when you start Excel. It then displayed them neatly on the screen, justified in rows and columns.

    It is such a dim memory that I can't remember if was in Woody's or in a magazine. I have tried a search on the boards but to no avail.

    Anybody got the remedy...... apart from a few memory pills!!?

    Jerry
    Jerry

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

    Re: Open more than one sheet on startup (97/XP)

    I don't know about new workbooks, but you can save a "workspace". This is a file with extension .xlw that stores information about the currently open workbooks and the way they are arranged within the main Excel window. If you open a workspace file, the workbooks will be opened and arranged the way they were when you saved the workspace file. If you save the workspace file in your XLSTART folder, the workbooks will be reopened and arranged when you start Excel.

    Is that what you meant?

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Open more than one sheet on startup (97/XP)

    Hi Hans

    Thanks for the quick response, I was watching you on Who's Online. The Workspace solution was going to be my final outcome for this particular project.

    The only reason I was thinking of getting muliple worksheets to open was I have colleague who does a lot of performance reports from multiple worksheets spread across our network and was hoping to make it easier for them to have a workbook that opened up multiple occurences of new worksheets so that they could open the required file,link them easily within the same window. Once linked they could save it as a workspace.

    It was just a "nice to have", but thinking about it I maybe over engineering, but I would still like to know. I will go'er hunting......

    Jerry
    Jerry

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Open more than one sheet on startup (97/XP)

    Hi Hans

    This bit of code staves off my hunger for the answer.

    Private Sub Workbook_Open()
    Dim count As Integer

    For count = 1 To 5

    ActiveWindow.NewWindow

    Next count

    Windows.Arrange ArrangeStyle:=xlTiled

    End Sub

    It opens 6 workbooks and tiles them accross the page. I was going to customise it later so that the user can choose the number of open workbooks they want.

    Cheers

    Jerry
    Jerry

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

    Re: Open more than one sheet on startup (97/XP)

    That code should actually open six windows on the same workbook and worksheet. Is that what you wanted? If you really wanted six different workbooks, then the code would need to be:

    <pre>Option Explicit

    Private Sub Workbook_Open()
    Dim count As Integer
    For count = 1 To 5
    Workbooks.Add
    Next count
    Windows.Arrange ArrangeStyle:=xlTiled
    End Sub
    </pre>

    Legare Coleman

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Open more than one sheet on startup (97/XP)

    Hans

    I've taken my memory pill!!!

    I remember now, this was one of your postings <post#=323433>post 323433</post#>

    I have tweaked the code (very slightly) to fit my needs. Cheers

    Jerry
    Jerry

Posting Permissions

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