Print Cheque by Microsoft Excel
hello everyone here we want to talk about the exo that helps us portage for
printing the chicks for example you have chicks and you want to insert the data
on it and you want to give it to some people for getting cash from Bank and
you don't want to write it by your hands so avoiding them is handwriting's and
misunderstanding or something like that friend you want to use it so five for
printing on those chips and another case you want to have checks for more than
one people for example 10 100 and you don't want to write it on on that checks
by your hand so you need an extra file for that reason we developed it Excel
that is developed based on the VBA and macros so if you open this Excel over
for the first time you can see the Year ribbon here that's says you have to
enable the macros on this 6:05 so please go ahead and enable the content of this
X so the first sheet you see is for entering the data the name of the person
you want to have check for the hem the amount of the chicks and the date of the
check that people can go to the bank and trash that after that you have to
specify the description why you getting this check why you need to give the
check to that person you need to write it right down here after specifying the
data as on the checks you have to specify the size of the checks for
example hi and length these are based on the centimetres so if you are working
with the inch please convert the inch to the centimeter and then enter the data
that in most cases the checks are produced by this size but if your bank
is different have different size please go and measure that the size of the
chicken eater here after that you have to specify the currency
that you want you are working at in the US dollar is it the Canadian dollar or
is a pound euro at UTC so please specify your currency and
after that is you are ready to have your print so first of all if you want to
have just one print you need to adjust the printer properties but if you need
to have checks for more than one people you need to have a list for example
something like this one here we have 3% these are the same because I just
entered the data and you have you can have more than three you can have 10 100
just go over here and add the person to the to the table before that is remove
all previous data because we you don't want to have check print checks on those
so after you remove all those they tell your list make sure you this is empty
and add to the list for example I change the name I want to have another check
for our education our Z and for example $1000 and I will add this one to my list
again someone else for example Alex Alex and it's just the
example and it's a payment for a house Rarity's for example $2,000 I don't know
at least one to the list as well so if you go to the list shit you can see
these data are submitted here okay so when you done is adjust the printer
property then you don't is adjust the printer properties if you click on this
screen button you will see the message that asks you if your printer is the
vertical or horizontal is based on your printer how the this printer will get
people is it horizontally or is it vertically for example in my case is
vertical and after that it's asked you to choose your check image it's not just
simply get an image by your phone from the check and select it here go
somewhere save your image for example in my case I have to go to this for
progress and goals okay it's this this one is my image check if you insert the
check you can see is much much bigger than what I expected
you have to shrink this image and place the image into this blue lines and you
if you see that this one is not included in the check so I will crop this one
until you and then I go to manage the image to fit on this blue lines okay
after you feed that you can see there is a text box you have to adjust the text
box into the right places for example here I need two smaller text box and
then I just adjusted here the dates each number for day and for month and date
and you are in the individual text box and the name and the description of why
we play this check so this should be comes here after you add just all the
text boxes into the right place you have to go and select one of these buttons
the first one just pin what you see here okay it just
for one print but if you want to print all these lists you need to choose the
blue one and if you want to readjust the printer you can select the orange one
here and do the same readjustments so for example I want to print just this
one I select the yellow one and I have to select a folder that the PDF file I
want to save it for example the same here and if I choose this folder the PDF
file will be placed there and if you go to that folder you can see there is a
PDF file there is no image under this text box is just a text box and if you
place the if you place your checks into the printer and after that you print
this one you will have all these data on your check
so for example you want to print all this list then you should just go and
press the blue one this one will ask you the destination folder as well I simply
just select that check print is followed here you should remember that your
folder name should be pasted right here and your chance you have to see this
name here after that press ok you can see the PDF file our generator and if
you go to the folder you will see all the PDF files here and you can simply
just print all of them by selecting click write and prints if you choose
this one all this PDF file will be printed and you have just place the
check in to your printer that select this all of your checks will be printed
properly before you print all those checks please use this excel file and
have some samples too and be sure you are working right with that if you are
okay and use the actual chip for printing leads thank you for listening I
hope this excel file helped you a lot we shoot at us