February 15th, 2011 at 08:29am
Under Forum
Is there any PDF reader that has a highlighting function that DOES NOT require OCR?
For many of the PDF readers I’ve used, they all have a highlighting function, but they all have to have the characters recognized as actual text. When I try to use OCR, the characters are lopsided if the scanned book page isn’t exactly straight and I can’t read it. So, I just want to draw yellow line on whatever I want to highlight. Is there any PDF reader/editor that can do this?
By Barcode Scanner
October 16th, 2008 at 04:47pm
Under Forum
Sum function in excel with addons.?
At work they use a barcode scanner to input information into Excel. I would like to sum all of the numbers in a certain column into a cell. This is usually easy, right? =Sum(E4:E100), or whatever. My problem is, this excel document has some addins, and code in these “E” cells that grabs its value from the barcode. I can only sum cells that have a barcode scanned in it, because then it shows a number, otherwise its a blank cell, and (my guess is) the code in it messes up the sum function because it shows #VALUE if I try to sum cells passed the ones with a number in them. But this kinda defeats the purpose… Is there a way to make it sum E:4 through last E cell with a number?
Best answer:
Try this event handler. It will sum all numeric values between E4 and the last row in column E containing data. It will ignore non-numeric entries. If you do not wish the sum to appear in F1, change the “F1″ reference to the cell you wish to display the total in.
Copy the code to the clipboard:
Private Sub Worksheet_selectionChange(ByVal Target As Range)
Dim LastRow
LastRow = Range(“E” & Rows.Count).End(xlUp).Row
Range(“F1″).Value = Application.Sum(Range(“E4:E” & LastRow))
End Sub
Select the appropriate worksheet and right click on the sheet tab.
Select ‘View Code’.
Paste the code into the sheet module editing area to the right.
Close the VBE and return to Excel.
Enter data.
By Barcode Scanner
February 7th, 2008 at 07:49pm
Under Forum
What is the function of the barcode application on the Nokia N95?
There is an application on the nokia n95. It is in the Office folder on the main menu. The application inside is barcode and when you enter it, it asks you to scan or save data?what does this mean?and what is this application used for?
Best answer:
It is used to scan bar codes particularly QR-Codes. Most of the time the bar code contains an encoded url of a mobile site.
tec-it.com/online-demos/tbarcode/barcode.aspx?code=MobileQRUrl&data=http%3a%2f%2ftec-it.com&dpi=96&modulewidth=fit
It makes use of your phone’s camera to scan the code, after that you will be able to browse the mobile site on your cellphone if you have an internet connection.
By Barcode Scanner
