scaning to exel
 

how do I scan a table into exel. My scaner is a HP 80 K series. Office
version is 2003

Joe

Try the code below:

Be sure to substitute the information for what you want.

HTH

Dennis

********************************************

Sub PageSetupAllSheets()

Dim EachSheet As Worksheet
For Each EachSheet In ActiveWorkbook.Worksheets
With EachSheet.PageSetup
' &F = File
' &A = Tab
' &D = Date
' &T = Time
' &P = Page
' &N = Pages
'
' NOTE: the "&8" that you see below is font size
'
' Chr(10) is a carrage return
'
'
.LeftFooter = "&8 &D &T"
.CenterFooter = "&8Your Name" ' & Chr(10) & "&D &T"
.RightFooter = "&8Page " & "&P of &N"
End With
Next EachSheet
MsgBox "Process Completed! Press OK to Continue"
End Sub


"Mick" wrote:

how do I scan a table into exel. My scaner is a HP 80 K series. Office
version is 2003

Mick,

My post above was for someone else.

To your question,

What software do you have that will "recognize" text from a scanned image?

I do not believe that Excel itself (although someone may have developed an
XL macro) will "recognize" text.

Normally one uses other S/W to "recognize" hen Copy/Paste the result into
Excel.

HTH

Dennis

"Mick" wrote:

how do I scan a table into exel. My scaner is a HP 80 K series. Office
version is 2003

Hi Mick,
If your scanner is one typically sold for home use, it probably includes some
software to create a Comma Separate Values (.csv), word document (.doc), or
an Excel 5 formatted file (.xls). One such program that has been included
in all of my scanners was "Text Bridge" by Xerox. You may have to look again
at the CD that came with your scanner. You might also get such software with
a printer purchased for home use.

Proper registration of the paper (horizontal regards to type) is very important
when scanning, but I expect the software probably makes some corrections for that.

You will have quite a bit of correcting to do afterwards, deleting cells,
correcting spelling, and numbers, but it should be a lot faster than
typing in all that data..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mick" wrote ...
how do I scan a table into exel. My scaner is a HP 80 K series. Office
version is 2003