Rowsource from another workbook

[ranswrt]

I have a workbook that I am using to create estimates on. I have another
workbook that contains the databases for the estimates. How do I set a
listbox rowsource from different workbook than the form with the listbox is
in?
Thanks

 

[JLGWhiz]

Maybe:
[OtherWorkbook.xls]Sheet1!a1:f25

Or if the wb name is two or more words:

'[Other Workbook.xls]Sheet1'!a1:f25

 

[ranswrt]

How do I do this when the range for the rowsource is named? The name I am
using is 'wrkshtrng'.

Maybe:
[OtherWorkbook.xls]Sheet1!a1:f25

Or if the wb name is two or more words:

'[Other Workbook.xls]Sheet1'!a1:f25

I have a workbook that I am using to create estimates on. I have another
workbook that contains the databases for the estimates. How do I set a
listbox rowsource from different workbook than the form with the listbox is
in?
Thanks

 

[Tim Zych]

I like to let Excel create it for me.

Dim rng as Range, RowSrc as String
Set rng =
Workbooks("SomeBook.xls").Worksheets("SomeSheet").Range("ListRange")
RowSrc = rng.address(External:=True)

or if it's a book-level range name

Dim rng as Range, RowSrc as String
Set rng = Workbooks("SomeBook.xls").Names("ListRange").RefersToRange
RowSrc = rng.Address(External:=True)


--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility
Now with Table Compare for quick table comparisons

 

[ranswrt]

That worked great Thank You

I like to let Excel create it for me.

Dim rng as Range, RowSrc as String
Set rng =
Workbooks("SomeBook.xls").Worksheets("SomeSheet").Range("ListRange")
RowSrc = rng.address(External:=True)

or if it's a book-level range name

Dim rng as Range, RowSrc as String
Set rng = Workbooks("SomeBook.xls").Names("ListRange").RefersToRange
RowSrc = rng.Address(External:=True)


--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility
Now with Table Compare for quick table comparisons