Cheque Print

S

Sana Sawal

can you please send me the sample of chequest in excel sheet



anoop kumar wrote:

Cheque Print S/w
29-Jul-09

You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

Previous Posts In This Thread:

Re: Printing Cheque of Different sizes from the same Worksheet
Suggestion: look into using 'mail merge' and printing from Wor
Debra Dalgleish posted this: There's an article on the Microsoft web site
that might help you

Answer Box: Numbers don't merge right in Wor
http://office.microsoft.com/en-ca/assistance/HA011164951033.asp

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has
instructions here

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.ht

about half way down the page
best wishe
--
Bernard V Liengm
Microsoft Excel MV
http://people.stfx.ca/bliengm
remove caps from emai


Hi,One way is to write VBA which picks up the info and resized the check
Hi

One way is to write VBA which picks up the info and resized the check
accordingly. For example suppose you have a range call Bank1 which contains
all the setting for column widths and so on for that banks checks then you
could use code to capture each item and then apply it to the appropriate
place in code. You could record the macro for changing all the items and
then replace the hardcoded entries with those picked up form the Bank1 range

If this helps, please click the Yes button

Cheers
Shane Devenshir

:

Printing Cheque of Different sizes from the same Worksheet
Hi All

Kindly mention yours email ID for the sample file

I have bank account in 4 banks and at present I am printing my cheque
through Excel on a laser printer

Cheque belonging to each bank are of different size (length an
width). On each cheque there are some basic fields (like "Name o
Payee, Amount in Figures, Amount in Words, Date, Mode of Payment
etc, which are to be filled by Cheque issuer. Presently the issue
fills these fields in Data Source sheets (HDFC3772 and SBOP5620) an
data is automatically VLOOKUPed in "Cheque" sheet)

At present I am maintaining a "Cheque" sheet "separately" for eac
bank, where fields have been placed in such a manner (at specifie
distance and of specified width) that when printed, the value of eac
fields comes out properly on a blank cheque. Field Values change
according to 'Cheque No' selected from Cell E1

Required Data is taken from Data Base sheets maintained for each ban
(i.e., HDFC3772 and SBOP5620

--Sheet named "CPC" (Cheque Printing Configuration) contains, for eac
bank's cheque, the physical measurements i.e., Size of the Cheque, th
distance of each field from top edge and left edge of the cheque, an
width of each field. The measurements are to be taken physically b
the user at first use. The defined name for the relevant range i
"CPCrng"

--Instead of separate "Cheque" sheet for each Bank, there is only on
"Cheque" sheet with the above fields on it (or may be Single user for
with Text boxes containing the required fields on it

--G1 on "Cheque" sheet contains Name of the Bank for which Cheques ar
to be printed

--Whenever we select the Bank Name from cell G1, the sheet / user for
and fields / text boxes thereon are automatically resized
redistanced as per the dimensions provided for that Bank in sheet CPC
Off course the Field values will then be based on Cheque No in Cel
E1, as at present

--The sample sheet contains the Data Source Sheet for 2 banks only
--Source Data for each bank surely will continue to reside in separat
sheets
--Name of Data Source worksheets and Heading of "CPCrng" are exactl
the same
--Cheque List in cell E1 has been configured to adjust for data sourc
as per Bank Name selected in G1.
--If the proposed solution needs "user form and text boxes", then
kindly tell how the formulae will be used in those text boxes, as
presently I don't know how to do that.
--A sample file alogwith the desired format will be provided on the
email ID Provided.

Regards
CA Kanwaljit Singh Dhunna

Cheque Printing Example
Hi CA Kanwaljit Singh Dhunna, Please Send that Cheque printing example.

Thanks & Regards

Ravi D

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

Cheque Print S/w
You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

for Cheque Print in Excel
Dear Boss,
Pls. send Excell for Cheque print

thanks

Excell Cheque print micro
Dear Sir,
Pls. Send Excel macro for cheque print]

thanks

Re : Chq Printing
Dear Anoop,

You want help or you want to help ?

Kanwaljit

Chq format
Sir ji,
Please send me the cheque format
Regards & Thanks
Hemant

There is no built-in format that will give, for example, $*******45,123.
There is no built-in format that will give, for example, $*******45,123.78

But you can generate the effect in a helper column
With money value in A1, this formula
="$"&REPT("*",20-LEN(TEXT(A1,"#,##0.00")))&TEXT(A1,"#,##0.00")
gives results like $**512,345,670,123.67
and works for amounts up to 9,999,999,999,999.99
Just vary the 20 for smaller or larger amounts

This formula
=REPT("*",21-LEN(TEXT(A1,"$#,##0.00")))&TEXT(A1,"$#,##0.00")
gives results like *****$512,345,678.45

best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

Bonsour=AE Bernard Liengme avec ferveur ;o))) vous nous disiez
Bonsour=AE Bernard Liengme avec ferveur ;o))) vous nous disiez :=20


;o)))

personnalised format :
$**#,##0.00

HTH

Printing Cheques from Excel
Hi,

Can u please provide me the cheque application which you created for different banks as I require it for my office work. I am in urgent need for the same I urge you to send me the same.


Submitted via EggHeadCafe - Software Developer Portal of Choice
MSChart For VB.Net
http://www.eggheadcafe.com/tutorial...4dc6-9aa7-4f6246763650/mschart-for-vbnet.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top