How can I scan images into seperate worksheets at once?

J

jwewing23

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?
 
G

Guest

jwewing23 said:
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?
Click to expand...

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
 
J

jwewing23

Thanks Bill. Unfortunately, I do not want the text to be editable and would
like the process to be simple as possible.
 
C

CLR

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
 
J

jwewing23

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
 
C

CLR

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
 
J

jwewing23

CLR, thank you. I will give it a try with them.

CLR said:
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
Click to expand...
 
Top