Results 1 to 6 of 6
  1. #1

    A little help with vbScripting

    I need help with this line of code that i copy pasted from XL macro.

    Cells.Find(What:="table2", After:=ActiveCell, LookIn:=xlFormulas, LookAt
    :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _

    This gives an error at character number 36 (expected ')').
    I belive this is in VBA and needs to convertd to VBS. any help will be appreciated.

  2. #2

    Re: A little help with vbScripting

    I searched the forum and found a an almost identical query, but the solution offered was inconclusive

  3. #3

    Re: A little help with vbScripting

    Nevermind, found the solution after searcing google

    ExcelApplicationObj.ActiveSheet.Cells.find("table2 ", ExcelApplicationObj.ActiveSheet.Cells(1),null ,null , 1, 2).Activate

  4. #4
    Senior Member
    Join Date
    Feb 2007
    Pittsburgh, USA

    Re: A little help with vbScripting

    This is not a QTP question.

  5. #5
    SQA Knight
    Join Date
    Jul 1999
    Grand Rapids, MI

    Re: A little help with vbScripting

    Here is a forum dedicated to all things vbScript, very similar to sqaforums.com:


    Like this forum you need to set up an account to ask questions.

  6. #6

    Re: A little help with vbScripting

    maybe for those who only record and play.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 05:44 PM.

Copyright BetaSoft Inc.