How do I look at other documents?
 

I'm attempting to create a set of spreadsheets that will be generated
automatically based on a master spreadsheet (i.e. taking a master schedule
for six people and having excel automatically generate the six individual
schedule). What would the command line be to refrence a different document
or a different sheet in the same document?

How do I look at other documents?
 

Many options here
Workbooks:
Dim wb as Workbook
Set wb = Workbooks("Book1.xls")
wb.Activate

Workbooks("Book1.xls").Activate

Windows("Book1.xls").Activate

Worksheets:
Dim ws as Worksheet
Set ws = Workbooks("Book1.xls").Sheets("Sheet1")
ws.Activate

Workbooks("Book1.xls").Sheets("Sheet1").Activate

Workbooks("Book1.xls").Sheets(1).Activate

I hope one of these methods works for you.

Charles

Sax wrote:
I'm attempting to create a set of spreadsheets that will be generated
automatically based on a master spreadsheet (i.e. taking a master schedule
for six people and having excel automatically generate the six individual
schedule). What would the command line be to refrence a different document
or a different sheet in the same document?