Question with OLE Control when using excel (linked to a seperate file):
I have 1 excel file that had 5 sheets in it... i need 5 ole objects on 1 form, 1 for each sheet in my excel workbook.. the problem is i dont know how to make the ole object show a particular sheet.. they all show the same sheet all the time... do i need to have these 5 sheets all in different workbooks.. if i were to do this, wouldnt that take up a lot of memory having 5 instances of excel open and hidden in the background?
Thanks
-Matt
