Results 1 to 4 of 4

Thread: Newbie Question

  1. Oct 30th, 2002, 02:49 AM #1
    Morpheus
    Morpheus is offline

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    52

    Newbie Question

    How do i do the following?

    "Don't forget to reference Microsoft Excel 8.0 Library Object or up first."


    How do i create this reference?


    All help apreciated.

    M
    Reply With Quote Reply With Quote
  2. Oct 30th, 2002, 02:52 AM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    You add a reference to a com library through the Project\References menu.
    Reply With Quote Reply With Quote
  3. Oct 30th, 2002, 03:02 AM #3
    Morpheus
    Morpheus is offline

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    52
    Thanks Heaps worked a treat
    Reply With Quote Reply With Quote
  4. Oct 30th, 2002, 03:02 AM #4
    alex_read
    alex_read is offline
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    goto your Project menu in vb & click onto the References submenu. Place a tick next to the "Microsoft Excel x.0 Object Library" & you will be able to access any Microsfot Excel objects such as playing with ranges or calling up a workbook.

    Note that the 8.0 version is the version of Excel you have installed (I think version 8 means it's Excel97), this might be a different number on your pc.

    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