Combobox with autofill across 2 documents

[bloodnovski]

This is my problem that will, hopefully, get solved here :
I figured out how to make a combobox which is activated by double click on a field, and which has autofill enabled features. I did that via some VBA programming, and the combobox works only in one document.
I need to know how to make the combobox(in one .xls file) use data from another .xls file that is opened and is located in the same folder as the .xls file of the combobox.

Thanks in advance people of excel forums
PS. If you didn't understand the problem, i will try to, somehow, make it more understanable.

[Tinbendr]

Just set an object to the other WB, then you can 'handle' it just like any other WB.

Set CurrWB = Activeworkbook

But it's even better if you can specify the WB.

Set SourceWB = Workbooks("Source FIle.xls")

Then test for your other WB

On Error Resume Next 'Turn error breaks off
Set DestWB = Workbooks("Dest File.xls")
On Error Goto 0 'Turn error breaks on
If Not DestWB is Not Nothing then

'do stuff here.

If you're using selection, try to port over to using ranges. No activation needed!

HTH