i come across this and works well for getting data from my scale but have a few questions if someone might can help me
1) I need help getting so that when i send the Capture command( AKA Hit the print button ) that it will let me chose which cell that number goes into and not jsut on the next line
2) how i can regex and have it auto take out the Ibs so its just the number itself
pike replied with this
- [/COLOR][COLOR=blue]If[/COLOR][COLOR=#333333] [/COLOR][COLOR=blue]Not[/COLOR][COLOR=#333333] .Data = vbNullString [/COLOR][COLOR=blue]Then[/COLOR][COLOR=#333333][/COLOR] lngRow = lngRow + 1 Cells(lngRow, 1).Value = replace(.Data,"Ibs","") [COLOR=darkgreen]' change the cell location in the cells function Cells(row,column) and use replace function to remove the Ibs[/COLOR] Range("L7").Value = "Transfer" [COLOR=blue]End[/COLOR] [COLOR=blue]If[/COLOR] [COLOR=#333333]
[/COLOR]But its still not allowing me to pick the Cell i want the Data too go into next it will still go too the direct one below also in the Replacing Function its working for the most part but here is example of what data is being captured from my scale and sent into excel
0 KG GR I need to remove any and all items besids the Number so ( ) and (KG GR) Needs too be deleted
Also every time i click open to have data pulled into excel it will delete the last entries any edit in the code that will stop this from happening ?