Display all current workbooks in combo box 2

[thomsons]

Hi,

I'm currently trying to populate a combo box with the names of all the excel files that are currently opened locally on my PC

I'm struggling to find the right code for obtaining the file names currently opened.

Any assistance would be greatly appreciated.

Cheers,
S.

 

[RobBroekhuis]

for each wb in application.workbooks
if not wb.isaddin then
MyComboBox.additem wb.name
end if
next wb


Rob