I am in the process of creating a form which will allow the users to insert a Word document into an OLE field. I could have the users perform the following instructions:
1. Right-clickon the OLE field to bring up the menu with the Insert Object option.
2. Click on Insert Object to open up the Insert Object Window.
3. Select "Create From File"
4. Click "Browse"
5. Select the file you wish to insert.
For the sake of simplicity, I would prefer for the users to simply click a command button and have a macro (or VB module) take the user to the "Browse" window, allowing them to simply select the file.
Unfortunately, I cannot get my macro to go very far. I have tired the following sequence: 1. GoToControl 2. InsertFile but I receive a message that the action "InsertFile" is not available. Although I am in the process of teaching myself VB, this went beyond my current skill level. Can someone point me in the right direction to get this sequence to work? As always, your insights have proven to be an invaluable resource. Thanks.
1. Right-clickon the OLE field to bring up the menu with the Insert Object option.
2. Click on Insert Object to open up the Insert Object Window.
3. Select "Create From File"
4. Click "Browse"
5. Select the file you wish to insert.
For the sake of simplicity, I would prefer for the users to simply click a command button and have a macro (or VB module) take the user to the "Browse" window, allowing them to simply select the file.
Unfortunately, I cannot get my macro to go very far. I have tired the following sequence: 1. GoToControl 2. InsertFile but I receive a message that the action "InsertFile" is not available. Although I am in the process of teaching myself VB, this went beyond my current skill level. Can someone point me in the right direction to get this sequence to work? As always, your insights have proven to be an invaluable resource. Thanks.
Last edited:
