Results 1 to 3 of 3

Thread: Application 'GoTo' Error With VB/Excel

  1. Jan 22nd, 2003, 01:47 PM #1
    camaro77
    camaro77 is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2002
    Posts
    17

    Application 'GoTo' Error With VB/Excel

    Well, I am back again. Excel is not recongizing the Application.GOTO method. The error highlights the .GOTO and states "Compile Error, Data Member or Method Not Found." I can connect to Excel through VB and I have already gotten a lot of information from Excel to Access VIA VB. I just keeping getting this error. HELP?

    Even after I activate the sheet, I can't pull values out of the current selected sheet. Any help would be appreciated.

    ~ Jason
    Reply With Quote Reply With Quote
  2. Jan 22nd, 2003, 02:46 PM #2
    phinds
    phinds is offline
    PowerPoster
    Join Date
    Aug 2001
    Location
    new jersey
    Posts
    2,904
    I don't know what your problem is, but there is a full VB/Excel tutorial project at:

    http://www.hobbithouseinc.com/VB

    that may help solve the problem since it shows how to do what you want to do.
    phinds
    www.hobbithouseinc.com/VB
    Reply With Quote Reply With Quote
  3. Jan 22nd, 2003, 02:50 PM #3
    phinds
    phinds is offline
    PowerPoster
    Join Date
    Aug 2001
    Location
    new jersey
    Posts
    2,904
    ... but NOT the "goto" problem. I don't know about that. The project will show how to select a sheet and get values from it.
    phinds
    www.hobbithouseinc.com/VB
    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