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?

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

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

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?

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?

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?

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?