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

[Eric D]

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]

"Eric D" <Eric [email protected]> wrote in message
news:[email protected]...
> 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.c...=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 :

>
> "Eric D" <Eric [email protected]> wrote in message
> news:[email protected]...
> > 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.c...=970078&page=1
>
> /Fredrik