Thread
:
create a fill-in form using a scanned-in semi-transparent overlay
View Single Post
#
3
Posted to microsoft.public.excel.programming
keepITcool
external usenet poster
Posts: 2,253
create a fill-in form using a scanned-in semi-transparent overlay
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
wrote in message
...
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
Reply With Quote
keepITcool
View Public Profile
Find all posts by keepITcool