Hi,
I'm new to VB, and I'm trying to add a bit of VB code to automatically insert a OLE object into a form (via a button). However, when I try to compile the code, I get a error message "compile error: can't find project or library" and it highlights the 'OLE1' object.
As I've never used OLE objects before in VBA before, I was wondering which reference library do I need to get the OLE object to work?
I've looked through all the available references in VB6 and added all the one's with 'OLE' in the title, but it still doesn't work.
Also, can anyone provide me with some template code on how to 'automatically' insert an excel document as an OLE object into a form (via a button), and to make it editable within the form? So far I have declared a field called 'LetterChecklist' with the type 'OLE Object'...but I need some advice on the VBA coding part.
Thanks,
Raymond
I'm new to VB, and I'm trying to add a bit of VB code to automatically insert a OLE object into a form (via a button). However, when I try to compile the code, I get a error message "compile error: can't find project or library" and it highlights the 'OLE1' object.
As I've never used OLE objects before in VBA before, I was wondering which reference library do I need to get the OLE object to work?
I've looked through all the available references in VB6 and added all the one's with 'OLE' in the title, but it still doesn't work.
Also, can anyone provide me with some template code on how to 'automatically' insert an excel document as an OLE object into a form (via a button), and to make it editable within the form? So far I have declared a field called 'LetterChecklist' with the type 'OLE Object'...but I need some advice on the VBA coding part.
Thanks,
Raymond