Preview Word/Excell File on Access Form

A

accessuser1308

I have created a form for previewing files stored on my computer. I have a
textbox that contains the entire link (C:\Directory\File.extension) to the
files I would like to preview. I was able to add a picture control to the
form and added code to make the image (from the text box) appear on the form.
I would like to do the same thing with word and excel files. I think I
would have to use an unbound OLE object?, but I don't know how to set up the
code. I will use a Select Case structure based on Right(textbox, 3). What
code do I need to input under the case for "doc" and "xls" to make the files
display in the OLE object...or is there a better way of doing this?

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top