| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access sheets in another workbook
Hi
How do I access a sheet in another workbook? Due to the data getting very large I wish to separate all my code into one excel xls and the data into another that way I can continue to develop the application without the need to cut and past all the sheets into my new xls each time I make a code change. Regards Stuby |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access sheets in another workbook
Workbooks("otherbook.xls").Worksheets("Sheet1") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuby" wrote in message ... Hi How do I access a sheet in another workbook? Due to the data getting very large I wish to separate all my code into one excel xls and the data into another that way I can continue to develop the application without the need to cut and past all the sheets into my new xls each time I make a code change. Regards Stuby |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access sheets in another workbook
That what I thought my code is as follows
Workbooks("h:\sdrdata.xls").Worksheets("SDRstats") .Active but I get a run-time error "9" subscript out of range Any thoughts Regards Stuby On Wed, 21 Apr 2004 19:49:48 +0100, "Bob Phillips" wrote: Workbooks("otherbook.xls").Worksheets("Sheet1") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuby" wrote in message ... Hi How do I access a sheet in another workbook? Due to the data getting very large I wish to separate all my code into one excel xls and the data into another that way I can continue to develop the application without the need to cut and past all the sheets into my new xls each time I make a code change. Regards Stuby |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access sheets in another workbook
open it.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuby" wrote in message ... Found the problem I think, which has created a new one. If I remove the h:\ it works which brings me to the next question, My file is stored on a server get to it I need to a path such as \\someserver\sharefolder\folder\ how do I get it to do this. Regards Stuby On Wed, 21 Apr 2004 19:00:54 GMT, (Stuby) wrote: That what I thought my code is as follows Workbooks("h:\sdrdata.xls").Worksheets("SDRstats" ).Active but I get a run-time error "9" subscript out of range Any thoughts Regards Stuby On Wed, 21 Apr 2004 19:49:48 +0100, "Bob Phillips" wrote: Workbooks("otherbook.xls").Worksheets("Sheet1") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuby" wrote in message ... Hi How do I access a sheet in another workbook? Due to the data getting very large I wish to separate all my code into one excel xls and the data into another that way I can continue to develop the application without the need to cut and past all the sheets into my new xls each time I make a code change. Regards Stuby |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access sheets in another workbook
Bob many thanks.
On Wed, 21 Apr 2004 20:27:01 +0100, "Bob Phillips" wrote: open it. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuby" wrote in message ... Found the problem I think, which has created a new one. If I remove the h:\ it works which brings me to the next question, My file is stored on a server get to it I need to a path such as \\someserver\sharefolder\folder\ how do I get it to do this. Regards Stuby On Wed, 21 Apr 2004 19:00:54 GMT, (Stuby) wrote: That what I thought my code is as follows Workbooks("h:\sdrdata.xls").Worksheets("SDRstats" ).Active but I get a run-time error "9" subscript out of range Any thoughts Regards Stuby On Wed, 21 Apr 2004 19:49:48 +0100, "Bob Phillips" wrote: Workbooks("otherbook.xls").Worksheets("Sheet1") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuby" wrote in message ... Hi How do I access a sheet in another workbook? Due to the data getting very large I wish to separate all my code into one excel xls and the data into another that way I can continue to develop the application without the need to cut and past all the sheets into my new xls each time I make a code change. Regards Stuby |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
access sheets in another workbook
No, workbooks refers to the workbooks collection, that is the workbooks open
in that application., not a workbook on a drive. Also it is Activate, not Active. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuby" wrote in message ... That what I thought my code is as follows Workbooks("h:\sdrdata.xls").Worksheets("SDRstats") .Active but I get a run-time error "9" subscript out of range Any thoughts Regards Stuby On Wed, 21 Apr 2004 19:49:48 +0100, "Bob Phillips" wrote: Workbooks("otherbook.xls").Worksheets("Sheet1") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Stuby" wrote in message ... Hi How do I access a sheet in another workbook? Due to the data getting very large I wish to separate all my code into one excel xls and the data into another that way I can continue to develop the application without the need to cut and past all the sheets into my new xls each time I make a code change. Regards Stuby |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing a Workbook But Restricting Access to Certain Sheets | Excel Discussion (Misc queries) | |||
| Access to sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
