Hi All,

Kindly mention yours email ID for the sample file.
>>>>>>>>>>>>>> Present Scenario >>>>>>>>>>>>>>>>>>>>

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

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

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

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

>>>>>>>>>>>>> Now here is What I wish >>>>>>>>>>>>>>>

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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user form
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 Cell
E1, as at present.

>>>>>>>>>>>>>> Notes >>>>>>>>>>>>>>>>>>>
--The sample sheet contains the Data Source Sheet for 2 banks only.
--Source Data for each bank surely will continue to reside in separate
sheets.
--Name of Data Source worksheets and Heading of "CPCrng" are exactly
the same.
--Cheque List in cell E1 has been configured to adjust for data source
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

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 Devenshire

"kanwalno1.Remove@gmail.com" wrote:

> Hi All,
>
> Kindly mention yours email ID for the sample file.
> >>>>>>>>>>>>>> Present Scenario >>>>>>>>>>>>>>>>>>>>
>
> I have bank account in 4 banks and at present I am printing my cheques
> through Excel on a laser printer.
>
> Cheque belonging to each bank are of different size (length and
> width). On each cheque there are some basic fields (like "Name of
> Payee, Amount in Figures, Amount in Words, Date, Mode of Payment"
> etc, which are to be filled by Cheque issuer. Presently the issuer
> fills these fields in Data Source sheets (HDFC3772 and SBOP5620) and
> data is automatically VLOOKUPed in "Cheque" sheet).
>
> At present I am maintaining a "Cheque" sheet "separately" for each
> bank, where fields have been placed in such a manner (at specified
> distance and of specified width) that when printed, the value of each
> fields comes out properly on a blank cheque. Field Values changes
> according to 'Cheque No' selected from Cell E1.
>
> Required Data is taken from Data Base sheets maintained for each bank
> (i.e., HDFC3772 and SBOP5620)
>
> >>>>>>>>>>>>> Now here is What I wish >>>>>>>>>>>>>>>
>
> --Sheet named "CPC" (Cheque Printing Configuration) contains, for each
> bank's cheque, the physical measurements i.e., Size of the Cheque, the
> distance of each field from top edge and left edge of the cheque, and
> width of each field. The measurements are to be taken physically by
> the user at first use. The defined name for the relevant range is
> "CPCrng".
>
> --Instead of separate "Cheque" sheet for each Bank, there is only one
> "Cheque" sheet with the above fields on it (or may be Single user form
> with Text boxes containing the required fields on it)
>
> --G1 on "Cheque" sheet contains Name of the Bank for which Cheques are
> to be printed.
>
> --Whenever we select the Bank Name from cell G1, the sheet / user form
> 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 Cell
> E1, as at present.
>
> >>>>>>>>>>>>>> Notes >>>>>>>>>>>>>>>>>>>
> --The sample sheet contains the Data Source Sheet for 2 banks only.
> --Source Data for each bank surely will continue to reside in separate
> sheets.
> --Name of Data Source worksheets and Heading of "CPCrng" are exactly
> the same.
> --Cheque List in cell E1 has been configured to adjust for data source
> 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
>

Suggestion: look into using 'mail merge' and printing from Word
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 Word
http://office.microsoft.com/en-ca/as...164951033.aspx

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

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.
best wishes

Dear Boss,
Pls. send Excell for Cheque print

thanks




kanwalno wrote:

Printing Cheque of Different sizes from the same Worksheet
30-Nov-08

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 cheques
through Excel on a laser printer.

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

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

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


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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user form
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 Cell
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 separate
sheets.
--Name of Data Source worksheets and Heading of "CPCrng" are exactly
the same.
--Cheque List in cell E1 has been configured to adjust for data source
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

Previous Posts In This Thread:

On Friday, November 28, 2008 1:07 PM
Bernard Liengme wrote:

Re: Printing Cheque of Different sizes from the same Worksheet
Suggestion: look into using 'mail merge' and printing from Word
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 Word
http://office.microsoft.com/en-ca/as...164951033.aspx

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

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

wrote in message


On Friday, November 28, 2008 4:35 PM
ShaneDevenshir wrote:

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 Devenshire

"kanwalno1.cut@gmail.com" wrote:

On Sunday, November 30, 2008 5:42 PM
kanwalno wrote:

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 cheques
through Excel on a laser printer.

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

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

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


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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user form
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 Cell
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 separate
sheets.
--Name of Data Source worksheets and Heading of "CPCrng" are exactly
the same.
--Cheque List in cell E1 has been configured to adjust for data source
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

On Monday, February 09, 2009 2:57 AM
Ravi D wrote:

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

Thanks & Regards

Ravi D

On Wednesday, July 29, 2009 3:36 AM
anoop kumar wrote:

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.

On Wednesday, July 29, 2009 3:37 AM
anoop kumar wrote:

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.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Visual Studio.NET 2005 Install Tips and Tricks
http://www.eggheadcafe.com/tutorials...t-2005-in.aspx

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

thanks



kanwalno wrote:

Printing Cheque of Different sizes from the same Worksheet
30-Nov-08

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 cheques
through Excel on a laser printer.

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

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

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


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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user form
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 Cell
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 separate
sheets.
--Name of Data Source worksheets and Heading of "CPCrng" are exactly
the same.
--Cheque List in cell E1 has been configured to adjust for data source
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

Previous Posts In This Thread:

On Friday, November 28, 2008 1:07 PM
Bernard Liengme wrote:

Re: Printing Cheque of Different sizes from the same Worksheet
Suggestion: look into using 'mail merge' and printing from Word
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 Word
http://office.microsoft.com/en-ca/as...164951033.aspx

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

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.
best wishes

Dear Anoop,

You want help or you want to help ?

Kanwaljit



Anoop Kumar wrote:

Excell Cheque print micro
28-Dec-09

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

thanks

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
JavaScript - prevent multiple form submittals
http://www.eggheadcafe.com/tutorials...vent-mult.aspx

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



kanwalno wrote:

Printing Cheque of Different sizes from the same Worksheet
30-Nov-08

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 cheques
through Excel on a laser printer.

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

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

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


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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user form
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 Cell
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 separate
sheets.
--Name of Data Source worksheets and Heading of "CPCrng" are exactly
the same.
--Cheque List in cell E1 has been configured to adjust for data source
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

Previous Posts In This Thread:

On Friday, November 28, 2008 1:07 PM
Bernard Liengme wrote:

Re: Printing Cheque of Different sizes from the same Worksheet
Suggestion: look into using 'mail merge' and printing from Word
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 Word
http://office.microsoft.com/en-ca/as...164951033.aspx

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

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

wrote in message


On Friday, November 28, 2008 4:35 PM
ShaneDevenshir wrote:

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 Devenshire

"kanwalno1.Del@gmail.com" wrote:

On Sunday, November 30, 2008 5:42 PM
kanwalno wrote:

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 cheques
through Excel on a laser printer.

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

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

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


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

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

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

--Whenever we select the Bank Name from cell G1, the sheet / user form
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 Cell
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 separate
sheets.
--Name of Data Source worksheets and Heading of "CPCrng" are exactly
the same.
--Cheque List in cell E1 has been configured to adjust for data source
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

On Monday, February 09, 2009 2:57 AM
Ravi D wrote:

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

Thanks & Regards

Ravi D

On Wednesday, July 29, 2009 3:36 AM
anoop kumar wrote:

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.

On Wednesday, July 29, 2009 3:37 AM
anoop kumar wrote:

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.

On Monday, December 28, 2009 4:35 AM
Anoop Kumar wrote:

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

thanks

On Monday, December 28, 2009 4:36 AM
Anoop Kumar wrote:

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

thanks

On Monday, December 28, 2009 4:55 AM
Kanwaljit Dhunna wrote:

Re : Chq Printing
Dear Anoop,

You want help or you want to help ?

Kanwaljit


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Custom Validation Using the Enterprise Library
http://www.eggheadcafe.com/tutorials...ation-usi.aspx

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

source: microsoft > public > excel