Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access VBA Training and help » Linking
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Linking
Resolved · Medium Priority · Version 2003
Reply
Linking
Is there a command to link to retieve data from Other MS products eg Excel, Word?For upcoming training course dates see: Pricing & availability
RE: Linking
Hi ShaileshThank you for your question.
To launch another application you need to work with an Application Object. Here is an example of how to launch Word and make it visible.
Sub WordExample()
'Opens word and creates a new document
Dim appWord As Object
Set appWord = CreateObject("Word.Application")
appWord.Visible = True ' Makes Word visible
End Sub
Record a macro in word or excel that selects the correct data then copy that code into the above code after the visible =True line. At the start every line in the other application you will need to enter appWord. (remember the dot).
It takes a little time to get it working smoothly but that should solve your problem.
Regards,
Laura GB
Tue 27 Jan 2009: Automatically marked as resolved.
|
