Tom, thanks for the reply. i found the problem. in my
VB code i was
opening a new application and not using the same one already opened.
(XLAPP = new excel.application) In this new XLAPP is where i would then
open the new file. (XLAPP.workbooks.open(File)).
For some reason, although the other application and source workbook
remained opened, it would not load the combo box's source data.
Now i just open the new file in the same application window and it
works just fine.
Thanks for your input.
Angelo
--
jellobze1
------------------------------------------------------------------------
jellobze1's Profile:
http://www.excelforum.com/member.php...o&userid=28431
View this thread:
http://www.excelforum.com/showthread...hreadid=480245