I'm hoping someone can help with this.
I don't have alot of experience with programming, so most of the time I just record a macro and cut and paste from there. What I haven't been able to find is how to send a data point (MbeSendDataPoint) to the origin of a cell. The cell's name is PNMBR. The cell contains text that I need to modify. If I can use a macro to send a data point to the cell, then I can use the MbeSendCommand "wordprocessor edit text" to edit the text without having to search for the cell and select it with the mouse.
From there, what would I need to do to have the macro then search for the next instance of that cell and loop until it reaches all the cells only once?
Thanks
Unknown said:MbeSendDataPoint
You're stuck in the 20th century with MicroStation BASIC. Prefer VBA to BASIC, for many reasons.
You can record a VBA macro just as easily as with BASIC.
VBA provides much nicer ways to locate an element than BASIC. VBA help is full of examples.
Finally, there's a VBA Forum where an enthusiastic bunch of macro people can exchange ideas.
Regards, Jon Summers LA Solutions
Have you tried "replace text" with in cells option ?