List Open Workbooks in a combobox
 

I am looking to create a combobox that has a list of every currently
open workbook in excel. what property would I need to pull to do
this? Would I need to use an array?

Thanks,
Jason


--
JasonSelf
------------------------------------------------------------------------
JasonSelf's Profile: http://www.excelforum.com/member.php...fo&userid=5330
View this thread: http://www.excelforum.com/showthread...hreadid=467950

List Open Workbooks in a combobox
 

You can loop through the selection and add them to the combobox

Dim wb As Workbook
For Each wb In Application.Workbooks
MsgBox wb.Name
Next wb


--
Regards Ron de Bruin
http://www.rondebruin.nl


"JasonSelf" wrote in message
...

I am looking to create a combobox that has a list of every currently
open workbook in excel. what property would I need to pull to do
this? Would I need to use an array?

Thanks,
Jason


--
JasonSelf
------------------------------------------------------------------------
JasonSelf's Profile: http://www.excelforum.com/member.php...fo&userid=5330
View this thread: http://www.excelforum.com/showthread...hreadid=467950

List Open Workbooks in a combobox
 

something like this
or maybe for each window in windows
try recording a macro and just select different workbooks and see what the
code turns up then use it as below

dim wb as workbook
for each wb in workbooks
combobox.item.add wb.name
next

"JasonSelf" wrote:


I am looking to create a combobox that has a list of every currently
open workbook in excel. what property would I need to pull to do
this? Would I need to use an array?

Thanks,
Jason


--
JasonSelf
------------------------------------------------------------------------
JasonSelf's Profile: http://www.excelforum.com/member.php...fo&userid=5330
View this thread: http://www.excelforum.com/showthread...hreadid=467950