how to detect coloured row with vb
how to detect coloured row with vb
(OP)
Hello, I am trying to find a way to operate on highlighted rows/strings.
I work with hierarchical db on mainframe, thus the command "find something" is essential for my job. When a string match, the system highlight it in red. Is there a way to tell vb to place the cursor on/before/after the highlighted string?
Thanks
I work with hierarchical db on mainframe, thus the command "find something" is essential for my job. When a string match, the system highlight it in red. Is there a way to tell vb to place the cursor on/before/after the highlighted string?
Thanks
RE: how to detect coloured row with vb
I think I asked someone lately who posted a similar request, what does Extra VB HELP have to say about the Selection object. Have you checked that out?
So when I did stuff like this, the user wanting to "find something" didn't just want to "find something" one time and the some other user wanted to "find something else" from the same screen.
So I ended up scraping EVERYTHING from each screen and putting ALL that data into an Excel sheet for ALL the items that the user wanted "Something" or "Something else".
Bottom line, I never just got one thing from a screen. Got the whole thing, parsed it and wrote to Excel table.
So I'd assign the text on the screen to a string, then find in the string, perhaps.
RE: how to detect coloured row with vb
The find command I use it' s not a vb command, it's a command embedded in the mainframe program I use to manage the db I work with. The result of that command is that the lines containing a matching string get highlighted, once at a time from beginning of file, and you can move to the next occurrence with pf12.
All I need is a way to make vb detect coloured string, just like excel where you can filter and search for cells/rows/columns formatted in a particular fashion.
RE: how to detect coloured row with vb
RE: how to detect coloured row with vb
RE: how to detect coloured row with vb
You'll need to experiment to discover if this is the case and has any significant.
RE: how to detect coloured row with vb
RE: how to detect coloured row with vb
RE: how to detect coloured row with vb
I have also tried pasting in excel, it gives you the possibility to paste as bitmap image, csv, unicode text, but it doesn' t preserve formatting, the text is pasted in black despite of its original colour in extra
RE: how to detect coloured row with vb
this is only available for VAX/VMS, UNIX, or asynchronous host. It is not available for IBM AS/400 or IBM Mainframe.
If someone can get this to work, Please, please post the code..
CODE
RE: how to detect coloured row with vb