SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    May 2006
    Location
    Penang
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    checking for string

    How do I check for a specific string strored in an excel sheet where the position of the string is not fixed? I have tried checkpoint datasase or string but it does not help as database text checks for string from left to right and when an exact match field is enabled, the result will always be fail as all the string before it will be capture as well.

    Pls advise
    Mag

  2. #2
    Junior Member
    Join Date
    Dec 2005
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: checking for string

    Try this one:

    Dim objexcel
    Dim rngFound
    Dim rng

    Set objExcel = createobject("Excel.application")

    objExcel.Workbooks.Open "C:\text.XLS",0
    objExcel.Sheets(1).Activate

    set rng = objexcel.Range("A1:H100")
    set rngFound = rng.Find("s")

    If rngFound is nothing Then
    msgbox "false"
    else
    msgbox "true"
    end if

    objExcel.Quit

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 12:14 AM.

Copyright BetaSoft Inc.