Consulting

Results 1 to 3 of 3

Thread: manipluate an object using value from field in database

  1. #1
    VBAX Newbie
    Joined
    Oct 2008
    Posts
    2
    Location

    manipluate an object using value from field in database

    In VBA I am reading a field from an access database. This field contains a name of an object in my vba application. How can I use the value read from the access database to manipulate the properties of this object in my application?

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,080
    Location
    Have you tried

    [vba]

    With ActiveSheet.OLEObjects(myObjectName)

    'do stuff
    End With
    [/vba]
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Newbie
    Joined
    Oct 2008
    Posts
    2
    Location
    I tried this and it didn't work. I am not doing this in excel. It is being done in a product called OSISoft PI ProcessBook. The object is a line.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •