Linking Excel, Word, Powerpoint, etc.

[jbento]

If a user is in a access form, and he/she gets a wild hair and wants to link a Excel, Word, Powerpoint, etc. type file to the record they are on, how would you go about doing something like this?

I have no clue on how to approach this.

Has anyone ever done something like this before?

Any help will do.

Thanks,

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[CajunCenturion]

Its done quite a bit to automate the various Office applications together. You can add object libraries from all of the Office applications into your project, and with these objects, can exercise most the functions available from those applications. Throughout the forum, there are many such examples.

If you have a specific wild hare that you'd like to discuss, then share your intensions, and in response, others will share their experiences.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[garethedmondson]

I have used an object from Office before - the file open dialogue box, however where do I get a list of what is available to use within Access?

regards

Gareth Edmondson

 

[oharab]

Pretty much any part of an application that can be coded in it's own environment is available in other vb COM environments, all you need to do is set the relevant references.
When you have set the reference, pressing F2 will show the object Browser, allowing you to browse the properties and methods available to you.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[janetlyn]

Ben, Right now it is setup so a person has to keep going from instructions in Access, to spreadsheets, back to instructions in Access, etc. I am doing a case where if a button is selected, a message box opens and says,

"Accounting Graphs are used in the financials, do you want to go to the graphs?" ,vbYesNo

If they choose Yes, I would like it to open the Excel file on top of the Access form so they can work on Excel while still viewing Access. If that is not possible, at least get to the Excel file.

Could you please explain your comment above? Thanks, JL

 

[PHV]

Take a look at the GetObject function.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884