Results 1 to 2 of 2

Thread: Controlling Word Or Excel (Resolved)

  1. Jan 11th, 2002, 04:09 AM #1
    Ecniv
    Ecniv is offline

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Controlling Word Or Excel (Resolved)

    Hi,

    I've done it in VB no problem. Create an object assign it to application.Word or application.excel and away you go. However, in VBA (MS Access) Object function/type doesn't exist.

    Does anyone know how to get an object of Excel/Word in VBA (Access) ? It has to be simple cause I did it before in Access for office automation... but I think I need a references...which?

    Thanks in advance

    Vince


    Hmm seems object is there... ta anyway
    Last edited by Ecniv; Jan 11th, 2002 at 04:16 AM.

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  2. Jan 11th, 2002, 04:47 AM #2
    alex_read
    alex_read is offline
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    That is what you're missing, the references.
    Tools Menu in Access > References >
    • Microsoft Excel x.0 Object library
    • Microsof Word x.0 Object Library

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width