Linking

Resolved · Medium Priority · Version 2003

Thu 8 Jan 2009, 16:07 Delegate Shailesh said...

Shailesh has attended:
Access VBA course

Linking

Is there a command to link to retieve data from Other MS products eg Excel, Word?

Wed 21 Jan 2009, 14:35 Trainer Laura said...

RE: Linking

Hi Shailesh

Thank 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.

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Linking

Linking

RE: Linking

Access articles

Access tip:

Hiding Multiple Table columns