Hi,
What I need to do here is allow the user to open up a relevent file connected with a record within our application. What we want is the external file to open embedded on one of our forms. The file could be a word document, excel spreadsheet, visio document, notepad document, powerpoint document etc etc.
They have control over what document to associate with what record and so they need to be able to open any of the above (or more) at any stage .At the moment there is 2 buttons doing this - first one when clicked gives the user a drive and directory box so that they can point to the file they want to associate with the record (this is saved on the database then) and the second button when pressed then uses shell to open the file. What I would like to do is open it within our own app on the second button. Is OLE the way to go with this and if so (I have never used OLE before) could you give me a simple example of how it works or point me to somewhere that will explain it to me.
Thanks in advance
John B
What I need to do here is allow the user to open up a relevent file connected with a record within our application. What we want is the external file to open embedded on one of our forms. The file could be a word document, excel spreadsheet, visio document, notepad document, powerpoint document etc etc.
They have control over what document to associate with what record and so they need to be able to open any of the above (or more) at any stage .At the moment there is 2 buttons doing this - first one when clicked gives the user a drive and directory box so that they can point to the file they want to associate with the record (this is saved on the database then) and the second button when pressed then uses shell to open the file. What I would like to do is open it within our own app on the second button. Is OLE the way to go with this and if so (I have never used OLE before) could you give me a simple example of how it works or point me to somewhere that will explain it to me.
Thanks in advance
John B
