If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Identifying Dublicate names and addresses in Exel data base and r. | Willgh | General Discussion | 1 | August 18th, 2004 11:21 AM |
using picture on charts in exel 2002 | [email protected] | Charts and Charting | 1 | April 13th, 2004 02:08 AM |