Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    paste special module (97)

    Hello, this question follows a previous post: is it possible to do a paste special module in access. i want to copy a table in access and then paste special (as unicode) to excel. can it be done? and how the heck is it done?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: paste special module (97)

    Umm - not exactly. You can create OLE code to do a PasteSpecial, but the problem is what do you paste? You can't really open a query, do an Edit Copy, in Access and so on without doing lots of DoCmd functions, and you have to worry about error conditions left and right. I think the code I pointed you to is probably your best bet.
    Wendell

Posting Permissions

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