Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clipboard - again!

    The macro below is executed from an Access97 form. It executes a macro that exists in my Word97. The Word97 macro simply places a "bit" of information in the clipboard. I have unsuccessfully looked everywhere for an instruction to add to the Access97 macro that would take the info placed in the clipboard by the Word97 macro and automatically insert it into a field in the Access97 form. Any ideas? Thanks in advance for your assistance!
    ++++++++++++++++++++++
    Private Sub Ctl10_Click()
    Dim chan As Variant, Macrochan, q$, mn$, tm$, tme$, cmd$
    ' On Error GoTo Cantstart:
    Macrochan = DDEInitiate("Winword", "System")
    q$ = Chr$(34)
    mn$ = "TenToTrack"
    tm$ = "[ToolsMacro .name ="
    tme$ = ", .Run]"

    cmd$ = tm$ + q$ + mn$ + q$ + tme$

    DDEExecute Macrochan, cmd$
    DDETerminate Macrochan
    Exit Sub

    Cantstart:
    MsgBox "Problem with DDEInitiate"
    Resume Next

    End Sub

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clipboard - again!

    If you have a copy of the Access 97 Developer's Handbook, from Sybex, you can find the necessary API declarations and code to manipulate the clipboard from Access.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clipboard - again!

    Found a solution. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •