LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Saved-workspace weirdness, questions

The first thing to try is to delete the workspace file (extension .xlw) and
to create it again.

If that doesn't solve your problems, enter code similar to the following in
the "ThisWorkbook" module of your primary workbook in Visual Basic (it avoids
some of the drawbacks of saved workspaces; maybe it will solve your link
problems, as well):

Private Sub Workbook_Open()

Dim MyPath As String
MyPath = ThisWorkbook.Path

Workbooks.Open (MyPath & "\workbook4.xls")
Workbooks.Open (MyPath & "\workbook3.xls")
Workbooks.Open (MyPath & "\workbook2.xls")

Workbooks(1).Activate

Application.ShowWindowsInTaskbar = False
Application.ShowWindowsInTaskbar = True

End Sub

This code was designed for the other workbooks to be in the same directory
as the primary one, so that I didn't have to specify the full path for each
file. The workbooks are opened in back-to-front order of how I want them to
"stack" on the Windows desktop. After that, I activate the primary workbook
to put it on top of the others.

On my system, something weird happens with the taskbar if I omit the last
two lines of the procedure; you may or may not need them on your system.

Good luck!
 
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
Adding a List of Members to a shared workspace Ezra Excel Discussion (Misc queries) 0 April 13th 06 06:27 PM
Workspace & Links referenced when workspace opened. LTB @ Miami, OK Excel Worksheet Functions 2 March 7th 06 10:28 PM
Workspace Question - Thanks In advance! Noclueatall Excel Discussion (Misc queries) 1 August 11th 05 07:58 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM
How to get saved old saved work that was saved over? Maral Excel Discussion (Misc queries) 1 February 20th 05 08:59 PM


All times are GMT +1. The time now is 04:00 AM.

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

About Us

"It's about Microsoft Excel"