create a fill-in form using a scanned-in semi-transparent overlay

[Guest]

I am using Excel 2003. I would like to be able to use a spreadsheet format
to fill in a preprinted form. In order to more easily position the fill-in
boxes accurately on the spreadsheet, it would be useful to be able to scan in
the preprinted form and have it displayed over the spreadsheet as a
semitransparent overlay sheet. That way columns and rows could be adjusted
to place the information to be printed on the form in a more precise manner.
Currently, this involves much trial and error and test printing. This could
save a lot of time and resources.

 

[Fredrik Wahlgren]

I am using Excel 2003. I would like to be able to use a spreadsheet format
to fill in a preprinted form. In order to more easily position the fill-in
boxes accurately on the spreadsheet, it would be useful to be able to scan in
the preprinted form and have it displayed over the spreadsheet as a
semitransparent overlay sheet. That way columns and rows could be adjusted
to place the information to be printed on the form in a more precise manner.
Currently, this involves much trial and error and test printing. This could
save a lot of time and resources.

There is a way to make a user form transparent. The code assumes there's a
window that it can operate on. Using Spy++, it seems as images are not
inside a window

http://www.tek-tips.com/viewthread.cfm?qid=970078&page=1

/Fredrik

 

[keepITcool]

this all sounds nice, and I've tried it a looooong time ago..

but: in 1990 Excel couldnot
and in 2005 Excel CANNOT PRINT WITH PRECISION.

For fill out forms you MUST use Word or something else, but DONT use
Excel.

the slightest change on graphics drivers/printer drivers/fonts/DPI
or whatever will screw up positioning. it may be 1px but can easily be
30 pixels out of whack..

Have you EVER tried to print a square graphic using Excel?
and...have you ever measured the results?

When he's finally got it exactly right on his PC and his printer,
he can start all over for the next user.






--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Fredrik Wahlgren wrote :