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
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