Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Using Excel to automate a preprint form?

I would like to use Excel with preprinted forms by somehow import an image of
the form and adjusting the rows and columns in order to supply the variable
data. Specifically tax forms.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 694
Default Using Excel to automate a preprint form?

Zero

I have tried this myself and it is really difficult.

In both case set the columns to width 1 so that you have many columns.

One way that I did it was to reconstruct the form in the excel window and
import the images.

The otherway I did it was to set up the cells and mask the form with an
imput sheet links to the blank sheet with only the data.

both ways are time consuming but work ok.


--
Hope this helps
Martin Fishlock


"Zero" wrote:

I would like to use Excel with preprinted forms by somehow import an image of
the form and adjusting the rows and columns in order to supply the variable
data. Specifically tax forms.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you automate numbers in Excel? Heather Stokes Excel Discussion (Misc queries) 2 July 11th 06 06:48 AM
Create form in Access, use as frontend for Excel bv111 Excel Discussion (Misc queries) 0 June 28th 06 11:27 PM
excel form not functioning correctly Rusty Excel Discussion (Misc queries) 2 June 1st 06 07:55 PM
Open Form Automatically in Excel File Bejewell New Users to Excel 1 November 16th 05 07:18 PM
Display form from an VB application in Excel kuhni Excel Discussion (Misc queries) 0 August 10th 05 07:04 PM


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"