hi, i'm new to the forums...
not sure if this is the right group, but here goes...
i have a worksheet within excel 2003 where cells contain dde hotlinks to a dde server...
seems to work ok...
what i'd like to do is have column A as one source with mutiple cells (each one a source) and column B as another source....
and then via either a change trigger or timed update map data from column A to column B... like sort of a data exchange....
i realise that to update the dde server (rather than just read) will require a ddepooke or something... is that right?
ideally, i'm thing a timed script that cross maps Ax to Bx for as many entties exist on a sequential loop?
assuming this can be done... moving on a level, instead of the sync being in a single direction... could it be done that a sync is done in both directions, depending on which entity changed? if not, i could probably live with the unidirectional sync...
i know a bit of vbscript if that helps... but have never delved into excel in that regard before..
thanks a lot
Neil
Bookmarks