View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Johnnyboy5[_2_] Johnnyboy5[_2_] is offline
external usenet poster
 
Posts: 99
Default open several workbooks at the same time

On 6 June, 16:02, Gord Dibben <gorddibbATshawDOTca wrote:
2003 version.

With the workbooks open. *FileSave Workspace.

To see the workbooks on the Taskbar....ToolsOptionsViewWindows in
Taskbar.

Gord

On Sat, 5 Jun 2010 10:23:22 -0700 (PDT), Johnnyboy5



wrote:
On 5 June, 18:05, Gord Dibben <gorddibbATshawDOTca wrote:
See help on saving a set of files as a workspace.


Basics are.............open your 3 or 4 workbooks.


ViewSave Workspace.


Default name is resume...........extension .xlw


Give your workspace whatever name you like and save.


I will use *mywkspace


Now close all workbooks.


Open mywkspace.xlw *and all books will open.


Gord Dibben *MS Excel MVP


On Sat, 5 Jun 2010 09:47:35 -0700 (PDT), Johnnyboy5


wrote:
I would like to repeatly open the same workbooks at the same time just
by selecting just one book and the other three or four will open with
it.


thanks *everyone


Thanks kind of works, *but I would like each workbook (4 of them) to
appear as tabs at the bottom)


oh I am using Excel 2003


Thanks

John