Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete the test documents in my recent documents? | Excel Discussion (Misc queries) | |||
turning 2007 excel documents into 2003 excel documents | Excel Discussion (Misc queries) | |||
excel documents won't open from my documents folder | Excel Discussion (Misc queries) | |||
Excel Documents Don't Appear in My Recent Documents | Excel Discussion (Misc queries) | |||
Two documents with the same name | Excel Discussion (Misc queries) |