Home |
Search |
Today's Posts |
#1
|
|||
|
|||
scaning to exel
how do I scan a table into exel. My scaner is a HP 80 K series. Office
version is 2003 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exel Calender drop down box 2005 | Excel Discussion (Misc queries) | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) |