Results 1 to 3 of 3

Thread: how to get Excel cell information in VB

  1. Sep 29th, 2003, 01:52 PM #1
    Obear
    Obear is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2002
    Location
    England, Bedfordshire
    Posts
    112

    how to get Excel cell information in VB

    Hi all, just a quicky, ive tried useing some samples but cant seem to get it to work so i thoguth i would ask here.

    If i want to search a perticular cell in excel and retreive the information stored there, what would be the command line?

    thanks for your time
    So Many things to do.....
    So little enthusiasm to do them.
    Reply With Quote Reply With Quote
  2. Sep 29th, 2003, 04:07 PM #2
    phinds
    phinds is offline
    PowerPoster
    Join Date
    Aug 2001
    Location
    new jersey
    Posts
    2,904
    the VB/Excel tutorial project at the link below my name will show you how to do that, but if you think it can be done in one line you should stop now as you are wasting your time.
    phinds
    www.hobbithouseinc.com/VB
    Reply With Quote Reply With Quote
  3. Oct 2nd, 2003, 03:55 AM #3
    lintz
    lintz is offline
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697
    If you want to display the contents of an Excel cell in VB use the below.

    Code:
    Text1 = objExcel.Range("A10").Value
    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