SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4
  1. #1
    Advanced Member
    Join Date
    Aug 2007
    Location
    Six Feet Under
    Posts
    717
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Excel cell value change event through Vbscript (Worksheet_Change)

    Hi folks,

    If any value from any worksheet cell get change we can fire an event using Macros.
    Private Sub Worksheet_Change(ByVal Target As Range)
    MsgBox "Cell value changed"
    End Sub
    I want to track that value changed using Excel Application object, I have tried but still not succeed….
    Any clues
    Thanks,
    Manish Bansal

    Checkout Blog Page At
    http://www.softtechlabs.com

  2. #2
    Senior Member
    Join Date
    Oct 2005
    Location
    London, U.K
    Posts
    1,804
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Excel cell value change event through Vbscript (Worksheet_Change)

    Msgbox Target

  3. #3
    Advanced Member
    Join Date
    Aug 2007
    Location
    Six Feet Under
    Posts
    717
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Excel cell value change event through Vbscript (Worksheet_Change)

    [ QUOTE ]
    Msgbox Target

    [/ QUOTE ]

    I am sorry i didn't understand!

    Turbografx,
    Actually i am creating a vbscript file which has a function of reading values from the excel sheet cell form an already open excel sheet, for this i am using getObject(,excel.application)
    but there an another external Application which is updating excel sheet values (live updates)
    here i want to run a my vbscript function which i am using to retrieve the values on every change of cell values to read the latest value...
    I hope i am clear this time..
    Please suggest me some workaround!
    Thanks,
    Manish Bansal

    Checkout Blog Page At
    http://www.softtechlabs.com

  4. #4
    Senior Member
    Join Date
    Oct 2005
    Location
    London, U.K
    Posts
    1,804
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Excel cell value change event through Vbscript (Worksheet_Change)

    How is your external application interacting with excel. It may not trigger the 'Worksheet_Change' event. Can't you just take a copy of the data before you run your tests, then again after?

 

 

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 12.50%
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 03:29 AM.

Copyright BetaSoft Inc.