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

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

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

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

access sheets in another workbook
 

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

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

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