grouping excel files

[nyrunner]

is there anyway to keep two separate excel files "grouped" ie always
associated with eachother. i have two models that i would always like
to open at the same time. the plan is to open them, then write a macro
that transfers data from one file to the next

any help would be greatly appreciated

 

[RC-]

For opening a second file using a macro:

In a new Sub routine (in the source file) add the following code in a Module
or the ThisWorkbook object.

Sub OpenDestination()

Workbooks.Open Filename:= _
"PATH-TO-FILE\FILE-NAME.xls"

End Sub

Then, in the ThisWorkbook object in VBA Code view, create a new event named:
Private Sub Workbook_Open()

OpenDestination
'If you want to change focus to the source file, remove the comment
below
'Windows("Source.xls").Activate

End Sub

When the source file is opened, the destination file will automatically be
opened and focus will be placed on the destiation file unless the comment
above is removed.

HTH,
RC-

 

[nyrunner]

right, this is helpful, i wanted to "group" the two files so they will
always be together, as new versions are saved in new directories... i
want some way of always keeping the files together

]

 

[Gord Dibben]

With both workbooks open.........File>Save Workspace.


Gord Dibben MS Excel MVP

 

[davegb]

right, this is helpful, i wanted to "group" the two files so they will
always be together, as new versions are saved in new directories... i
want some way of always keeping the files together

]

For opening a second file using a macro:

In a new Sub routine (in the source file) add the following code in a Module
or the ThisWorkbook object.

Sub OpenDestination()

    Workbooks.Open Filename:= _
        "PATH-TO-FILE\FILE-NAME.xls"

End Sub

Then, in the ThisWorkbook object in VBA Code view, create a new event named:
Private Sub Workbook_Open()

    OpenDestination
    'If you want to change focus to the source file, remove the comment
below
    'Windows("Source.xls").Activate

End Sub

When the source file is opened, the destination file will automatically be
opened and focus will be placed on the destiation file unless the comment
above is removed.

- Show quoted text -- Hide quoted text -

- Show quoted text -

Don't know of anyway to "group" them so they always open together. You
can create a "Workspace" which, when double-clicked, will open them
both. But you can still open them separately by double-clicking on the
individual file.