Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I scan images into seperate worksheets at once?
I am trying to use my scanner to insert documents into excel. When I do it,
it adds all the images into one sheet that overlap each other. How can I get excel to add each image to its own worksheet? |
#2
|
|||
|
|||
jwewing23 wrote:
I am trying to use my scanner to insert documents into excel. When I do it, it adds all the images into one sheet that overlap each other. How can I get excel to add each image to its own worksheet? What I do is scan into a file, then run that file through OCR software and then that data goes into Excel. But then I want data I can manipulate with Excel -- I've never had a desire to put images into Excel. Bill |
#3
|
|||
|
|||
Thanks Bill. Unfortunately, I do not want the text to be editable and would
like the process to be simple as possible. "Bill Martin -- (Remove NOSPAM from addre" wrote: jwewing23 wrote: I am trying to use my scanner to insert documents into excel. When I do it, it adds all the images into one sheet that overlap each other. How can I get excel to add each image to its own worksheet? What I do is scan into a file, then run that file through OCR software and then that data goes into Excel. But then I want data I can manipulate with Excel -- I've never had a desire to put images into Excel. Bill |
#4
|
|||
|
|||
I normally just scan my documents and save to a .jpg file and then open
Excel, switch to whatever Sheet I want, then do Insert Picture FromFile, then pick whatever picture I want and Insert............ Perhaps if you described exactly how you are scanning documents directly into Excel we could help more. Vaya con Dios, Chuck, CABGx3 "jwewing23" wrote in message ... I am trying to use my scanner to insert documents into excel. When I do it, it adds all the images into one sheet that overlap each other. How can I get excel to add each image to its own worksheet? |
#5
|
|||
|
|||
I am using an automatic document feeder scanner with a stack of pages on it
that each need to be scanned into excel on its own worksheet. In excel, I am going to Insert Picture From scanner or camera "CLR" wrote: I normally just scan my documents and save to a .jpg file and then open Excel, switch to whatever Sheet I want, then do Insert Picture FromFile, then pick whatever picture I want and Insert............ Perhaps if you described exactly how you are scanning documents directly into Excel we could help more. Vaya con Dios, Chuck, CABGx3 "jwewing23" wrote in message ... I am trying to use my scanner to insert documents into excel. When I do it, it adds all the images into one sheet that overlap each other. How can I get excel to add each image to its own worksheet? |
#6
|
|||
|
|||
Only thing I can tell you from here is that as long as Excel is on Sheet1,
that is where all Inserted images will go, you must somehow switch Sheets for each image. Manually will do it of course, but maybe someone in the Programming group can give you some fancy Change-Event kind of macro to do it automatically as each image is scanned in. Sorry I can't be more help, but I'll be watching this thread with interest to see how you make out..... Vaya con Dios, Chuck, CABGx3 "jwewing23" wrote: I am using an automatic document feeder scanner with a stack of pages on it that each need to be scanned into excel on its own worksheet. In excel, I am going to Insert Picture From scanner or camera "CLR" wrote: I normally just scan my documents and save to a .jpg file and then open Excel, switch to whatever Sheet I want, then do Insert Picture FromFile, then pick whatever picture I want and Insert............ Perhaps if you described exactly how you are scanning documents directly into Excel we could help more. Vaya con Dios, Chuck, CABGx3 "jwewing23" wrote in message ... I am trying to use my scanner to insert documents into excel. When I do it, it adds all the images into one sheet that overlap each other. How can I get excel to add each image to its own worksheet? |
#7
|
|||
|
|||
CLR, thank you. I will give it a try with them.
"CLR" wrote: Only thing I can tell you from here is that as long as Excel is on Sheet1, that is where all Inserted images will go, you must somehow switch Sheets for each image. Manually will do it of course, but maybe someone in the Programming group can give you some fancy Change-Event kind of macro to do it automatically as each image is scanned in. Sorry I can't be more help, but I'll be watching this thread with interest to see how you make out..... Vaya con Dios, Chuck, CABGx3 "jwewing23" wrote: I am using an automatic document feeder scanner with a stack of pages on it that each need to be scanned into excel on its own worksheet. In excel, I am going to Insert Picture From scanner or camera "CLR" wrote: I normally just scan my documents and save to a .jpg file and then open Excel, switch to whatever Sheet I want, then do Insert Picture FromFile, then pick whatever picture I want and Insert............ Perhaps if you described exactly how you are scanning documents directly into Excel we could help more. Vaya con Dios, Chuck, CABGx3 "jwewing23" wrote in message ... I am trying to use my scanner to insert documents into excel. When I do it, it adds all the images into one sheet that overlap each other. How can I get excel to add each image to its own worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with Dates between 2 seperate worksheets | Excel Discussion (Misc queries) | |||
Protect/unprotect all worksheets | Excel Worksheet Functions | |||
Opening worksheets in seperate excel tabs | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Using excel to select only matching images... | Excel Discussion (Misc queries) |