Help please?

G

Greg B

Hi all I am currently writing a program where I have made up a userform
which asks the user to type in three bits of information.

Date of the report
what is the report of
does this person need to see a doctor.

I was hoping to have the code place these on to the worksheet and then
either:(this is where i need advice)

bring up a scanning program, scan the image and then create a hyperlink
which i know is very complicated.
but I would like for the scanning to be done at the same time as the
questions so that the hyperlink isnt confused.


so it would be like this

A B C
D

1 15 Sep 2005 Xray of Foot Yes

So the hyperlink would be placed in row "D"

Any advice would be appreciated

Thanks

Greg
 
M

Mike Fogleman

Scan what image? The Monitor screen? Why Scan when you can Print.
Hyperlink to what? And I think you meant in Column D.
A little more help on the total picture of what you are trying to do.
It sounds like an Employee injury report.

Mike F
 
G

Greg B

Thanks for the response, I never made it really clear as such. What I am
looking to do is for reports such as injury etc. I want to implement a
userform which asks for the basic information date of report what it is for
etc. Then I want to have that information stored on to a worksheet. I am
fine will all of the code for this but what I am trying to work out is that
I want to scan the particular report to the harddrive and have a hyperlink
to it. I wanted to have it go onto the workbook but I guess that would make
the program pretty bulky to run.

I hope this helps

Greg
 
M

Mike Fogleman

My suggestion would be to manually scan the paper injury documents to a
folder, then insert them into the worksheet as an icon. The icon can be
sized to fit on a row and when double-clicked, will open up the full sized
document in probably Photo Editor. That way the scanned objects are not
stored in Excel, only an icon that links to it. Automating this in a macro
would require much more skill than I can offer, or this newsgroup would want
to tackle.
However, someone may want to prove me wrong.

Mike F
 
Top