View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
jellobze1[_2_] jellobze1[_2_] is offline
external usenet poster
 
Posts: 1
Default Combo box problem


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