Found it on another site. Thanx anyway. It is actually very easy...
activecase.rang e("A2:Z5000").S ort key1:=activecas e.range("a2"), key2:=activecas e.range("d2"), key3:=activecas e.range("e2")
chilidogie
Last Activity: Apr 19 '13, 06:59 PM
Joined: Mar 2 '12
Location:
-
Sort excel sheet from VB-5
Does anyone have the format to sort an excel sheet from VB ? I add data to an existing sheet using the object ACTIVECASE, etc... example: ACTIVECASE.CELL S(6,20)="Y". I update the F column (Payment received) thru VB. I understand there is a SORT where I can specify ACTIVECASE.SORT ... but I don't know the full speification for sort range, sort columns, nor accesding/descending, etc. I have a header row so I assume my range would be... -
Winsocks and conflict of systems/ports
We currently use couchdb that recieves a continuous data freed from the lab on port 5945. Our old system used a file feed from a TCPIP connection to the lab. We could preprocess those files to ensure patient name, lab results, etc, so when the data went in to our database, it was clean. Now, the couchdb gets the data directly then ports it to our system. We cannot see anything prior to our system.
Will I ruin/mess up the data... -
Actually...hunt and peck...I found my own answer. After each significant data change, I just put a form.refresh.
I made it only significant events so I don't get the screen chatter if it is after each line feed.
Cheers !Leave a comment:
-
VB5 form looses focus
I have a VB5 project completed. When it is running, it updates the file line count, number found, etc. If I switch to another window (email/explorer...) while it is running, it freezes the display until the process is complete. Can I somehow reset the focus so that the display continues to update, even if I switch to another window ?
Thank you !!
No activity results to display
Leave a comment: