|
-
Mar 21st, 2001, 12:14 AM
#1
Thread Starter
Hyperactive Member
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
[vbcode]
'*****************************
MsgBox "MCD :: [email protected]", vbInformation + vbOKOnly, "User"
'*****************************
[/vbcode]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|