Ïðîãðàìíîå îáåñïå÷åíèå äëÿ ýêîíîìèñòîâ

Ìèíèñòåðñòâî îáðàçîâàíèÿ Ðåñïóáëèêè Áåëàðóñü

ÌÎÃÈËÅÂÑÊÈÉ ÌÀØÈÍÎÑÒÐÎÈÒÅËÜÍÛÉ ÈÍÑÒÈÒÓÒ

Èíñòèòóò ïîâûøåíèÿ êâàëèôèêàöèè è ïåðåïîäãîòîâêè êàäðîâ

Êàôåäðà ñîâåðøåíñòâîâàíèÿ ïðîôåññèîíàëüíûõ çíàíèé

ÊÓÐÑÎÂÎÉ ÏÐÎÅÊÒ

Ïî äèñöèïëèíå: ” Ïðèêëàäíîå ïðîãðàìíîå îáåñïå÷åíèå “

ÒÅÌÀ ÏÐÎÅÊÒÀ: Ðàçðàáîòêà ñèñòåìû “Ñîçäàíèå Ïëàò¸æíûõ Ïîðó÷åíèé»

Ñëóøàòåëü ãð. ÈÍÔ-2 Ãóñåâ À.Ñ.

Ðóêîâîäèòåëü ïðîåêòà: Çàâ. êàô. ÀÑÓ,. Ñ.Ê.Êðóòîëåâè÷.

Ìîãèëåâ, 2000 ã.


Ñîäåðæàíèå

Ñòð.

1

ÐÀÇÐÀÁÎÒÊÀ ÒÐÅÁÎÂÀÍÈÉ Ê ÐÀÁÎÒÅ

1.1

Àíàëèç ïðåäìåòíîé îáëàñòè

3

1.2.

Ïîñòàíîâêà çàäà÷è

3-4

2.

ÏÐÎÅÊÒÈÐÎÂÀÍÈÅ ÏÐÎÃÐÀÌÌÍÎÃÎ ÏÐÎÄÓÊÒÀ

2.1.

Ðàçðàáîòêà èíôîðìàöèîííîé ìîäåëè ñèñòåìû

4-5

2.2

Ðàçðàáîòêà ìàòåìàòè÷åñêîé ìîäåëè

5-6

2.3

Îïðåäåëåíèå òðåáîâàíèé ê òåõíè÷åñêèì ñðåäñòâàì

7

3.

ÐÀÇÐÀÁÎÒÊÀ ÏÐÎÃÐÀÌÍÎÃÎ ÎÁÅÑÏÅ×ÅÍÈß.

3.1

Ðàçðàáîòêà ñòðóêòóðû ïðîãðàììû

7

3.2

Îïðåäåëåíèå ôîðìû ïðåäñòàâëåíèÿ âõîäíûõ è âûõîäíûõ äàííûõ.

8-9

3.3

Àëãîðèòì ðåøåíèÿ çàäà÷è.

9-10

3.4.

Ðàçðàáîòêà è òåñòèðîâàíèå ïðîãðàììíîãî ìîäóëÿ.

11

Çàêëþ÷åíèå.

11

Ñïèñîê èñïîëüçîâàííûõ ëèòåðàòóðíûõ èñòî÷íèêîâ.

12

ÏÅÐÅ×ÅÍÜ ÃÐÀÔÈ×ÅÑÊÎÃÎ ÌÀÒÅÐÈÀËÀ ÍÀÈÌÅÍÎÂÀ-

1.

Àëãîðèòìû îñíîâíûõ ïðîãðàììíûõ ìîäóëåé

2.

Ñòðóêòóðà ïðîãðàììíîãî îáåñïå÷åíèÿ

3.

Âõîäíûå è âûõîäíûå ôîðìû


1.ÐÀÇÐÀÁÎÒÊÀ ÒÐÅÁÎÂÀÍÈÉ Ê ÐÀÁÎÒÅ

1.1Àíàëèç ïðåäìåòíîé îáëàñòè.

Ïå÷àòü ïëàò¸æíûõ ïîðó÷åíèé îñóùåñòâÿåò ïðàêòè÷åñêè ëþáàÿ îðãàíèçàöèÿ.

Ïîýòîìó àâòîìàòèçàöèÿ ýòîé çàäà÷è èìååò áîëüøîå çíà÷åíèå .

Àâòîìàòèçàöèÿ ýòîé ïðîáëåììû ñâîäèò ýòè ðàáîòû ê íåñëîæíûì îïåðàöèÿì íà êîìïüþòåðå.

1.2.Ïîñòàíîâêà çàäà÷è

Äëÿ ðåøåíèÿ ýòîé çàäà÷è íåîáõîäèìî ñîçäàòü ïðèëîæåíèå ñ ïîìîùüþ êîòîðîãî ìîæíî áûëî áû õðàíèòü äàííûå «Ïëàòåëüùèêîâ». Ýòî áóäåò áàçà äàííûõ ñîäåðæàùàÿ:

  1. Íîìåð «Ïëàòåëüùèêà»

  2. Íàèìåíîâàíèå «Ïëàòåëüùèêà»

  3. Íàèìåíîâàíèå Áàíêà «Ïëàòåëüùèêà»

  4. Ð/Ñ «Ïëàòåëüùèêà»

  5. ÓÍÍ «Ïëàòåëüùèêà»

  6. Êîä Áàíêà «Ïëàòåëüùèêà»

Êðîìå ýòîãî íåîáõîäèìî ñîçäàòü áàçó äàííûõ â êîòîðîé õðàíèòü äàííûå «Ïîëó÷àòåëåé» ïëàòåæåé. Ýòî áóäåò áàçà äàííûõ ñîäåðæàùàÿ:

  1. Íîìåð «Ïîëó÷àòåëåé»

  2. Íàèìåíîâàíèå «Ïîëó÷àòåëåé»

  3. Íàèìåíîâàíèå Áàíêà «Ïîëó÷àòåëåé»

  4. Ð/Ñ «Ïîëó÷àòåëåé»

  5. ÓÍÍ «Ïîëó÷àòåëåé»

  6. Êîä Áàíêà «Ïîëó÷àòåëåé»

  7. Âèä îïåðàöèè

  8. Íàçíà÷åíèå ïëàòåæà

  9. Êîä íàçíà÷åíèÿ ïëàòåæà

Êðîìå ýòîãî íåîáõîäèìî ñîçäàòü «Áàçó äàííûõ» â êîòîðîé õðàíèòü äàííûå Ïðîèçâåä¸ííûõ ïëàòåæåé. Ýòî áóäåò «Áàçà äàííûõ» ñîäåðæàùàÿ:

  1. Íîìåð «Ïëàò¸æíîãî ïîðó÷åíèÿ»

  2. Äàòà ïëàòåæà

  3. Êîä Áàíêà «Ïîëó÷àòåëåé»

  4. ÓÍÍ «Ïîëó÷àòåëåé»

  5. Íàèìåíîâàíèå «Ïîëó÷àòåëåé»

  6. Íàèìåíîâàíèå Áàíêà «Ïîëó÷àòåëåé»

  7. Ð/Ñ «Ïîëó÷àòåëåé»

  8. Äàòà ïîëó÷åíèÿ òîâàðà, îêàçàíèÿ óñëóã

  9. Ñóììà ïëàòåæà

  10. Âèä îïåðàöèè

  11. Êîä íàçíà÷åíèÿ ïëàòåæà

  12. Ïàðàìåòð “Ìåñòî ïå÷àòè”

  13. Íàçíà÷åíèÿ ïëàòåæà

 ðàñ÷åòå ó÷àñòâóþò «Ñóììà ïëàòåæà». Äëÿ ýòîãî íåîáõîäèìî îáåñïå÷èòü ââîä ÷èñëîâîé èíôîðìàöèè ïî ýòîìó ïóíêòó.

Äëÿ óñêîðåíèÿ ïîñëåäóþùåé ðàáîòû ïîëüçîâàòåëþ íåîáõîäèìî áóäåò çàëîëíÿòü ñîîòâåòñòâóþùèå ïîëÿ «Áàçû äàííûõ» «Ïîëó÷àòåëåé ïëàòåæåé». È ñîõðàíÿòü ýòè íàííûå. Ýòî íàìíîãî óñêîðèò ïîñëåäóþþùåå ñîçäàíèå ïëàò¸æíûõ ïîðó÷åíèé. Ñîîòâåòñòâåííî íåîáõîäèìî ïðåäóñìîòðåòü ïðîãðàììûå ôóíêöèè êîíòðîëèðóþùèå èíäèâèäóàëüíîñòü êàæäîé çàïèñè.

Äëÿ ïîñëåäóþùåãî áûñòðîãî ôîðìèðîâàíèÿ îò÷¸òîâ öåëåñîîáðàçíî çâÿçàòü ïîëÿ «Áàçû äàííûõ» «Ïîëó÷àòåëåé» è ïîëÿ «Áàçû äàííûõ» «Ïëàòåæåé» ñ ïîìîùüþ èíäåêñîâ.

Î÷åíü óäîáíûì ýëåìåíòîì äëÿ ïîëüçîâàòåëÿ áûëî áû îðãàíèçàöèÿ íàâèãàöèè ïî áàçå «Ïëàòåæåé» , à òàêæå ïî áàçå «Ïîëó÷àòåëåé» è áàçå «Ïëàòåëüùèêîâ». Êðîìå ýòîãî óäàëåíèå è èçìåíåíèå èíôîðìàöèè ïîçâîëèëî áû óñòðàíÿòü èç ðàñ÷åòà òå çàïèñè êîòîðûå íå íóæíû .

Äëÿ îðãàíèçàöèè äîñòóïà ê áàçàì èõ êîððåêòèðîâêè , äîïîëíåíèÿ , óäàëåíèÿ è.ò.ä. íóæíî îðãàíèçîâàòü íåñêîëüêî äèàëîãîâ ñ óäîáíûì è áûñòðûì äëÿ ïîëüçîâàòåëÿ äîñòóïîì ê íóæíûì åìó çàïèñÿì.

Äëÿ îáüåäèíåíèÿ âñåãî âûøå ïåðå÷èñëåííîãî íåîáõîäèìà ñèñòåìà

êîòîðàÿ ïîçâîëèò ïîëüçîâàòåëþ ïåðåõîäÿ îò îäíîãî ýëåìåíòà ìåíþ ê äðóãîìó âûïîëíÿòü òå èëè èíûå ïðîãðàìíûå äåéñòâèÿ. Ïðè ïîìîùè åå ïîëüçîâàòåëü ìîæåò âûáèðàòü è âûçûâàòü äèàëîã , îñóùåñòâëÿòü íàâèãàöèþ ïî áàçå äàííûõ (ò.å. ïåðåìåùàòüñÿ ìåæäó çàïèñÿìè ), óäàëÿòü ëèáî âîñòàíàâëèâàòü çàïèñü, çàïóñêàòü ïðîöåäóðó ñîçäàíèÿ îò÷¸òîâ è âûâîä íà ïå÷àòü èòîãîâ è.ò.ä.

  1. ÏÐÎÅÊÒÈÐÎÂÀÍÈÅ ÏÐÎÃÐÀÌÌÍÎÃÎ ÏÐÎÄÓÊÒÀ

2.1. Ðàçðàáîòêà èíôîðìàöèîííîé ìîäåëè

Èíôîðìàöèîííûå ñèñòåìû îðèåíòèðîâàíû íà õðàíåíèå è ìîäèôèêàöèþ ïîñòîÿííî ñóùåñòâóþùåé èíôîðìàöèè.  íàøåì ñëó÷àå íóæíî ñîçäàòü òàêóþ ñèñòåìó êîòîðàÿ óäîâëåòâîðÿëà ñëåäóþùèì ñâîéñòâàì:

  1. Ïîääåðæèâàëà ó÷åò Ïëàòåëüùèêîâ

  2. Ïîääåðæèâàëà äëÿ êàæäîãî îòäåëüíîãî Ïëàòåëüùèêà åãî ëè÷íûå áàçû äàííûõ (Ñïèñîê Ïîëó÷àòåëå ïëàòåæåé, Ñïèñîê Ïðîèçâåä¸ííûõ ïëàòåæåé )

  3. Ïîääåðæèâàëà ïðîöåäóðó äîáàâëåíèÿ â áàçó íîâûõ Ïîëó÷àòåëå ïëàòåæåé è ìîäèôèêàöèþ óæå èìåþùèåñÿ çàïèñè, à òàê æå ïîääåðæèâàëà óäàëåíèå èç áàçû äàííûõ ñóùåñòâóþùèõ çàïèñåé.

  4. Ïîääåðæèâàëà ïåðåõîä íà ñäåäóþùèé ãîä (íà÷àëî íóìåðàöèè ïëàò¸æíûõ ïîðó÷åíèé ñ 1)

  5. Âîçìîæíîñòü ôîðìèðîâàíèÿ îò÷¸òîâ ïî çàäàííûì âðåìåííûì ðàðàìåòðàì ñ ïîñëåäóþùèì âûâîäîì íà ïå÷àòü.

Èíòåðôåéñ

ïîëüçîâàòåëÿ

Îò÷åòû

Ðàáî÷èé

Ëèñò

Excel

Ââîä

è

êîððåêòèðîâêà

äàííûõ

Ðàáî÷èé

Ëèñò

Excel

Ðàáî÷èé

Ëèñò

Excel

Ðåãëàìåíòèðî-

âàííûå

çàïðîñû

Ðèñóíîê 1.

2.2 Ðàçðàáîòêà ìàòåìàòè÷åñêîé ìîäåëè .

 áàçå äàííûõ â êîòîðîé ñîäåðæèòñÿ ïðîèçâåä¸ííûå ïëàòåæè, çíà÷åíèå ñóììû ïëàòåæà è åñòü òå äàííûå ó÷àñòâóþùèå â îò÷¸òå çà ðàñ÷èòûâàåìûé çàäàííûé âðåìåííîé ïåðèîä. Ò.ê. ôîðìèðîâàíèå îò÷¸òà ìîæåò áûòü êàê ïî âñåì ïîëó÷àòåëÿì òàê è ïî îòäåëüíî âçÿòîìó ïîëó÷àòåëþ ïëàòåæà òî ìàòåìàòè÷åñêèå ôîðìóëû äîëæíû âûãëÿäåëü ñëåäóþùèì îáðàçîì.

Ôîðìóëà ïî âñåì ïîëó÷àòåëÿì ïëàòåæà:

Ñóììà çà âûáðàííûé âðåìåííîé ïåðèîä = ñóììå âñåõ ïðîèçâåä¸ííûõ ïëàòåæåé çà âûáðàííûé ïåðèîä.

Ôîðìóëà ïî âûáðàííîìó ïîëó÷àòåëþ ïëàòåæà:

Ñóììà çà âûáðàííûé âðåìåííîé ïåðèîä = ñóììå âñåõ ïðîèçâåä¸ííûõ ïëàòåæåé çà âûáðàííûé ïåðèîä.

2.3 Îïðåäåëåíèå òðåáîâàíèé ê òåõíè÷åñêèì ñðåäñòâàì.

Ìèíèìàëüíûå òðåáîâàíèÿ äëÿ ýôôåêòèâíîé ðàáîòû ðàçðàáîòàííîé ÈÑ ÿâëÿþòñÿ:

Pentium 233 ÌÃö

32 Ìá ïàìÿòè

Æåñòêèé äèñê êàê ìèíèìóì 200 Ìá

Âèäåîêàðòà 0,5 Ìá

Ìîíèòîð VGA ïîääåðæèâàþùèé ðåæèìû ðàáîòû 800õ600

Äëÿ áîëåå êîìôîðòíîé è áûñòðîé ðàáîòû íåîáõîäèìî èñïîëüçîâàòü:

Pentium II 366 ÌÃö /Celeron è âûøå

64 Ìá ïàìÿòè

Æåñòêèé äèñê 2.5 Ãá è âûøå

Âèäåîêàðòà 1-2-4 ÌÁ

Ìîíèòîð SVGA ïîääåðæèâàþùèé ðåæèìû ðàáîòû 800õ600 è

1024õ768.

Äëÿ ïå÷àòè ìîæíî èñïîëüçîâàòü ëþáûå ìàòðè÷íûå, ñòðóéíûå, èëè ëàçåðíûå ïðèíòåðû.

3. ÐÀÇÐÀÁÎÒÊÀ ÏÐÎÃÐÀÌÌÍÎÃÎ ÎÁÅÑÏÅ×ÅÍÈß

    1. Ðàçðàáîòêà ñòðóêòóðû ïðîãðàììû

Ïðîãðàììà ïðåäñòàâëÿåò ñîáîé ôàéë íàäñòðîéêè Excel97 èìåþùèé

âñòðîåííûé êîä Visual Basic for Application. Òàê æå èìååòñÿ ÷åòûðèôàéëà Excel97 ïðåäñòàâëÿþùèå ñîáîé:

  1. Ôàéë áàçû äàííûõ Ïëàòåëüùèêîâ . ñîñòîèò èç äâóõ ëèñòîâ. Ãäå îäèí ëèñò ñîäåðæèò èíôîðìàöèþ î ãîäàõ â òå÷åíèè êîòîðûõ èñïîëüçîâàëàòü ïðîãðàììà. À äðóãîé èíôîðìàöèþ î Ïîëó÷àòåëÿõ ïëàòåæåé.

  2. Ôàéë áàçû äàííûõ Ïîëó÷àòåëåé ïëàòåæåé. Ïåðâîíà÷àëüíî ñîäåðæèò îäèí ëèñò. Äîáàâëåíèå è óäàòåíèå ëèñòîâ â êíèãå ïðîèñõîäèò äèíàìè÷åñêè â çàâèñèìîñòè îò êîë-âà Ïëàòåëüùèêîâ. Äðóãèìè ñëîâàìè íà êàæäîãî Ïëàòåëüùèêà îòâîäèòñÿ îäèí ëèñò ÿâëÿþùåéñÿ áàçîé äàííûõ Ïîëó÷àòåëåé äàííîãî Ïëàòåëüùèêà.

  3. Ôàéë áàçû äàííûõ Ïëàòåæíûõ Ïîðó÷åíèé. Ïåðâîíà÷àëüíî ñîäåðæèò äâà ëèñòà. Äîáàâëåíèå è óäàòåíèå ëèñòîâ â êíèãå ïðîèñõîäèò äèíàìè÷åñêè â çàâèñèìîñòè îò êîë-âà Ïëàòåëüùèêîâ. Äðóãèìè ñëîâàìè íà êàæäîãî Ïëàòåëüùèêà îòâîäèòñÿ îäèí ëèñò ÿâëÿþùåéñÿ áàçîé äàííûõ Ïëàòåæíûõ Ïîðó÷åíèé äàííîãî Ïëàòåëüùèêà. Äðóãîé ëèñò ÿâëÿåòñÿ ÷èñòûì áëàíêîì îò÷¸òà.

  4. Ôàéë ïëàòåæíîãî ïîðó÷åíèÿ. Ñîáñòâåííî ýòîò ôàéë ñîäåðæèò îäèí ëèñò ÿâëÿþùåéñÿ áëàíêîì ïëàò¸æíîãî ïîðó÷åíèÿ.

Âñòðîåííûé êîä VBA ñîäåðæèò ïðîöåäóðû è ôóíêöèè ïîääåðæèâàþùèå ýëåìåíòû óïðàâëåíèÿ ,à òàêæå ïðîöåäóðû âîðìèðîâàíèÿ îò÷¸òà, ïðîöåäóðû äîáàâëåíèÿ è óäàòåíèÿ ëèñòîâ â êíèãàõ, äîáàâòåíèÿ è óäàíëåíèÿ ôàéëîâó÷àñòâóþùè÷ â îò÷¸òàõ, ïðîöåäóðû êîíòðîëÿ ââîäèìîé ïîëüçîâàòåëåì èíôîðìàöèè, è ò.ä.

Äàííàÿ ïðîãðàìììà ÿâëÿåòñÿ ïîëíîñòüþ îòêðûòîé äëÿ äàëüíåéøåãî èçìåíåíèÿ è ìîäèôèêàöèè. Èíôîðìàöèÿ íàáðàííàÿ â ýòîé ñèñòåìå ìîæåò áûòü èñïîëüçîâàíà â äðóãèõ ïðèëîæåíèÿõ èñïîëüçóþùèõ ñðåäñòâà

Microsoft Office.

3.2.Îïðåäåëåíèå ôîðìû ïðåäñòàâëåíèÿ âõîäíûõ è âûõîäíûõ äàííûõ.

Ãëàâíàÿ (ïåðâàÿ ôîðìà) ñîñòîèò:

  1. Êíîïêà ïåðåõîäà â ôîðìó ÎÒ×ÅÒÛ

  2. Êíîïêà ïåðåõîäà â ôîðìó ÏËÀÒÅËÜÙÈÊÈ

  3. Ïîëå ÈÍÒÅÐÀÊÒÈÂÍÀß ÑÏÐÀÂÊÀ

  4. Âûïàäàþùåãî ñïèñêà ÂÛÁÎÐ ÏÎËÓ×ÀÒÅËß

  5. Ïîëå ÍÀÈÌÅÍÎÂÀÍÈÅ ÏÎËÓ×ÀÒÅËß

  6. Ïîëå ÄÀÒÀ

  7. Ïîëå ÍÀÈÌÅÍÎÂÀÍÈÅ ÁÀÍÊÀ ÏÎËÓ×ÀÒÅËß

  8. Ãðóïïû êíîïîê äëÿ ðàáîòû ñ äàòîé ÑÅÃÎÄÍß, ÏËÞÑ ÄÅÍÜ, ÌÈÍÓÑ ÄÅÍÜ

  9. Ïîëå Ð/Ñ ÏÎËÓ×ÀÒÅËß

  10. Ïîëå ÂÈÄ ÎÏÅÐÀÖÈÈ

  11. Ïîëå ÊÎÄ ÁÀÍÊÀ ÏÎËÓ×ÀÒÅËß

  12. Ïîëå ÄÀÒÀ ÏÎËÓ×ÅÍÈß ÒÎÂÀÐÀ, ÎÊÀÇÀÍÈß ÓÑËÓÃ

  13. Ïîëå ÊÎÄ ÍÀÇÍÀ×ÅÍÈß ÏËÀÒÅÆÀ

  14. Ïîëå ÓÍÍ ÏÎËÓ×ÀÒÅËß

  15. Ïîëå ÂÂÅÄÈÒÅ ÑÓÌÌÓ

  16. Ãðóïïû êíîïîê-ïåðåêëþ÷àòåëåé Ì/Ï-ìåñòî ïå÷àòè, Á/Ï-áåç ïå÷àòè, ÏÓÑÒÎ-íåò íèêàêèõ íàäïèñåé â ïë. ïîðó÷åíèè íà ìåñòå äëÿ ïå÷àòè.

  17. Ïîëå ÂÂÅÄÈÒÅ ÍÀÇÍÀ×ÅÍÈÅ ÏËÀÒÅÆÀ

  18. Ðàäèîêíîïêà äëÿ ïåðåõîäà ôîðìû â ðåæèì ïðîñìîòðà áàçû äàííûõ ñòàðûõ ïë. ïîðó÷åíèé ÏÎÑÌÎÒÐÅÒÜ ÑÒÀÐÛÅ ÏËÀÒ¨ÆÊÈ

  19. Êíîïêà ÑÎÕÐÀÍÈÒÜ ÍÎÂÎÅ ÏÎÐÓ×ÅÍÈÅ

  20. Êíîïêà ÄÎÁÀÂÈÒÜ ÏÎËÓ×ÀÒÅËß

  21. Êíîïêà ÂÍÅÑÒÈ ÈÇÌÅÍÅÍÈß Â ÄÀÍÍÛÅ Î ÏÎËÓ×ÀÒÅËÅ

  22. Êíîïêà ÓÄÀËÅÍÈÅ ÏÎËÓ×ÀÒÅËÅ

  23. Êíîïêà ÂÛÕÎÄ

  24. Ñêðûòîé êíîïêè ÏÅ×ÀÒÜ ÍÎÂÎÃÎ ÏËÀÒ¨ÆÍÎÅ ÏÎÐÓ×ÅÍÈß

  25. Ñêðûòîé êíîïêè ÏÐÅÄÎÑÌÎÒÐ

  26. [image]Ñêðûòîé âûïàäàþùèé ñïèñîê äëÿ âûáîðà êîë-âà êîïèé äëÿ ïå÷àòè

Ðèñ 3.

Ïðè ïîìîùè ðàäèîêíîïêè âèä èíôîðìàöèîííîé ÷àñòè ìîæåò ìåíÿòñÿ.

Äëÿ âíåñåíèÿ íîâûõ äàííûõ î ïîëó÷àòåëÿõ ïëàòåæåé è ôîðìèðîâàíèÿ íîâûõ ïë. ïîðó÷åíèé îíà èìååò âèä ïðèâåäåííûé âûøå, äëÿ íàâèãàöèè è ðåäàêòèðîâàíèÿ ñòàðûõ ïë. ïîðó÷åíèé îíà ïðèíèìàåò ñëåäóþùèé âèä.

  1. Êíîïêà ïåðåõîäà â ôîðìó ÎÒ×ÅÒÛ

  2. Êíîïêà ïåðåõîäà â ôîðìó ÏËÀÒÅËÜÙÈÊÈ

  3. Ïîëå ÍÎÌÅÐ ÏË. ÏÎÐÓ×ÅÍÈß

  4. Ïîëå ÈÍÒÅÐÀÊÒÈÂÍÀß ÑÏÐÀÂÊÀ

  5. Ïîëå ÍÀÈÌÅÍÎÂÀÍÈÅ ÏÎËÓ×ÀÒÅËß

  6. Ïîëå ÄÀÒÀ

  7. Ïîëå ÍÀÈÌÅÍÎÂÀÍÈÅ ÁÀÍÊÀ ÏÎËÓ×ÀÒÅËß

  8. Ãðóïïû êíîïîê äëÿ ðàáîòû ñ äàòîé ÑÅÃÎÄÍß, ÏËÞÑ ÄÅÍÜ, ÌÈÍÓÑ ÄÅÍÜ

  9. Ïîëå Ð/Ñ ÏÎËÓ×ÀÒÅËß

  10. Ïîëå ÂÈÄ ÎÏÅÐÀÖÈÈ

  11. Ïîëå ÊÎÄ ÁÀÍÊÀ ÏÎËÓ×ÀÒÅËß

  12. Ïîëå ÄÀÒÀ ÏÎËÓ×ÅÍÈß ÒÎÂÀÐÀ, ÎÊÀÇÀÍÈß ÓÑËÓÃ

  13. Ïîëå ÊÎÄ ÍÀÇÍÀ×ÅÍÈß ÏËÀÒÅÆÀ

  14. Ïîëå ÓÍÍ ÏÎËÓ×ÀÒÅËß

  15. Ïîëå ÂÂÅÄÈÒÅ ÑÓÌÌÓ

Ðèñ3.

  1. Ãðóïïû êíîïîê-ïåðåêëþ÷àòåëåé Ì/Ï-ìåñòî ïå÷àòè, Á/Ï-áåç ïå÷àòè, ÏÓÑÒÎ-íåò íèêàêèõ íàäïèñåé â ïë. ïîðó÷åíèè íà ìåñòå äëÿ ïå÷àòè.

  2. Ïîëå ÂÂÅÄÈÒÅ ÍÀÇÍÀ×ÅÍÈÅ ÏËÀÒÅÆÀ

  3. Ðàäèîêíîïêà äëÿ ïåðåõîäà ôîðìû â ïåðâîíà÷àëüíûé ðåæèì ÂÅÐÍÓÒÜÑß Ê ÑÎÇÄÀÍÈÞ ÏËÀÒ¨ÆÊÈ

  4. Êíîïêà ÂÍÅÑÒÈ ÈÇÌÅÍÅÍÈß Â ÑÒÀÐÓÞ ÏËÀÒ¨ÆÊÓ

  5. Êíîïêà äëÿ ïðîñìîòðà ïðîøëîãîäíèõ ïë. ïîðó÷åíèé ÇÀ ÏÐÎØËÛÉ ÃÎÄ

  6. Êíîïêà ÏÅ×ÀÒÜ ÑÒÀÐÎÃÎ ÏËÀÒ¨ÆÍÎÃÎ ÏÎÐÓ×ÅÍÈß

  7. Êíîïêà äëÿ ïåðåõîäà ïî ñòàðûì ïë. ïîðó÷åíèÿì

  8. Êíîïêà äëÿ ïåðåõîäà â êîíåö ñïèñêà ïë. ïîðó÷åíèé Ê ÊÎÍÖÓ ÑÏÈÑÊÀ ÏËÀÒ¨ÆÅÊ

  9. Ïîëå äëÿ ââîäà íîìåðà ïë. ïîðó÷åíèÿ ê êîòîðîìó ñëåäóåò ñäåëàòü ïåðåõîä

  10. Êíîïêà äëÿ ââåä¸ííîãî íîìåðà ïë. ïîðó÷åíèÿ ê êîòîðîìó ñëåäóåò ñäåëàòü ïåðåõîä ÏÅÐÅÉÒÈ ÏÎ ÍÎÌÅÐÓ

  11. Êíîïêà ÂÛÕÎÄ

  12. Êíîïêà ÏÐÅÄÎÑÌÎÒÐ

  13. Âûïàäàþùèé ñïèñîê äëÿ âûáîðà êîë-âà êîïèé äëÿ ïå÷àòè

[image]Ðèñ4.

Ïðè ïîìîùè êíîïêè Îò÷¸òû ïðîèñõîäèò ïåðåõîä â ôîðìó îò÷¸òîâ. Ôîðìà îò÷¸òîâ èìååò ñëåäóþùèé âèä:

  1. Êíîïêà ïåðåõîäà â ãëàâíóþ ôîðìó ÍÀÇÀÄ Ê ÏËÀÒ¨ÆÊÀÌ

  2. Äâåíàäöàòü ôëàæêîâ íà êàæäûé ìåñÿöãîäà ñîîòâåòñòâåííî

  3. Êíîïêà ïåðåõîäà â ôîðìó ÏËÀÒÅËÜÙÈÊÈ

  4. Âûïàäàþùèé ñïèñîê ÑÏÈÑÎÊ ÏÎËÓ×ÀÒÅËÅÉ

  5. Âûïàäàþùèé ñïèñîê ÑÏÈÑÎÊ ÏËÀÒÅËÜÙÈÊÎÂ

  6. Êíîïêà ÇÀ I-É ÊÂÀÐÒÀË äëÿ áûñòðîãî âûäåëåíèÿ ôëàæêîâ I-ãî êâàðòàëà

  7. Êíîïêà ÇÀ II -É ÊÂÀÐÒÀË Ë äëÿ áûñòðîãî âûäåëåíèÿ ôëàæêîâ II-ãî êâàðòàëà

  8. Êíîïêà ÇÀ III-É ÊÂÀÐÒÀË äëÿ áûñòðîãî âûäåëåíèÿ ôëàæêîâ III-ãî êâàðòàëà

  9. Êíîïêà ÇÀ IV-É ÊÂÀÐÒÀË äëÿ áûñòðîãî âûäåëåíèÿ ôëàæêîâ IV-ãî êâàðòàëà

  10. Êíîïêà ÇÀ ÃÎÄ äëÿ áûñòðîãî âûäåëåíèÿ âñåõ ôëàæêîâ ãîäà

  11. Ïîëå ãîäà îò÷¸òà

  12. Êíîïêà ÏËÞÑ ÃÎÄ

  13. Êíîïêà ÌÈÍÓÑ ÃÎÄ

  14. Êíîïêà ñáðîñ äëÿ ñíÿòèÿ àêòèâèçàöèè ñî âñåõ ôëàæêîâ ìåñÿöåâ

  15. Ñêðûòàÿ êíîïêà óäàëåíèÿ ôàéëîâ îò÷¸òà. Êíîïêà ïîÿâëÿåòñÿ åñëè èìååòñÿ õîòü áû îäèí ôàéë ñî ñòàðûìè îò÷¸òàìè.

  16. Ñïðàâî÷íîå ïîëå âûäà¸ò èíôîðìàöèþ î âûáðàííîì äëÿ îò÷¸òà ïîëó÷àòåëå è ñôîðìèðîâàííîì îò÷¸òå

  17. Ñïðàâî÷íîå ïîëå âûäà¸ò èíôîðìàöèþ î âûáðàííîì äëÿ îò÷¸òà ïëàòåëüùèêå

  18. Ïîëå ÐÅÇÓËÜÒÀÒ. Ñäåñü âûâîäÿòñÿ èòîãîâûå äàííûå.

  19. Êíîïêà ÑÔÎÐÌÈÐÎÂÀÒÜ ÎÒרÒ

  20. Êíîïêà ÏÐÎÑÌÎÒÐ ÎÒרÒÀ

  21. Êíîïêà ÏÅ×ÀÒÜ ÎÒרÒÀ

  22. Êíîïêà ÑÔÎÐÌÈÐÎÂÀÒÜ ÎÒ×¨Ò ÏÎ ÂÑÅÌ ÏÎËÓ×ÀÒÅËßÌ

  23. Âûïàäàþùèé ñïèñîê äëÿ âûáîðà êîïèé ïðè ïå÷àòü îò÷¸òà

  24. [image]Ïîëå ÈÍÒÅÐÀÊÒÈÂÍÎÉ ÑÏÐÀÂÊÈ

  25. Êíîïêà ÂÛÕÎÄ

Ðèñ5.

Ïðè ïåðåõîäå â ãëàâíóþ ôîðìó ñ ïîìîùüþ êíîïêè ÍÀÇÀÄ Ê ÏËßÒ¨ÆÊÀÌ. Ïîëüçîâàòåëü ìîæåò ïåðåéòè ê ôîðìå ïëàòåëüùèêè. Ýòà ôîðìà ñîäåðæèò ñëåäóþùèå ýëåìåíòû:

  1. Êíîïêà ïåðåõîäà â ãëàâíóþ ôîðìó ÍÀÇÀÄ Ê ÏËÀÒ¨ÆÊÀÌ

  2. Âûïàäàþùèé ñïèñîê äëÿ âûáîðà ÏËÀÒÅËÜÙÈÊÀ

  3. Ïîëå ÍÀÈÌÅÍÎÂÀÍÈÅ ÏËÀÒÅËÜÙÈÊÀ

  4. Ïîëå ÍÀÈÌÅÍÎÂÀÍÈÅ ÁÀÍÊÀ ÏËÀÒÅËÜÙÈÊÀ

  5. Ïîëå Ð/Ñ ÁÀÍÊÀ ÏËÀÒÅËÜÙÈÊÀ

  6. Ïîëå ÓÍÍ ÏËÀÒÅËÜÙÈÊÀ

  7. Ïîëå ÊÎÄ ÁÀÍÊÀ ÏËÀÒÅËÜÙÈÊÀ

  8. Êíîïêà äëÿ àêòèâèçàöèè âûáðàííîãî ïëàòåëüùèêà ÑÄÅËÀÒÜ ÝÒÎÃÎ ÏËÀÒÅËÜÙÈÊÀ ÒÅÊÓÙÈÌ Â Ï/Ï

  9. Êíîïêà ÄÎÁÀÂÈÒÜ ÏËÀÒÅËÜÙÈÊÀ

  10. Êíîïêà ÓÄÀËÈÒÜ ÏËÀÒÅËÜÙÈÊÀ

  11. Êíîïêà ÂÍÅÑÒÈ ÈÇÌÅÍÅÍÈß Â ÄÀÍÍÛÅ Î ÏËÀÒÅËÜÙÈÊÅ

[image]Ðèñ 6.

    1. Àëãîðèòì ðåøåíèÿ çàäà÷è.

Ðàñìîòðèì àëãîðèòì ïðîöåäóðû ðàñ÷åòà ñóììû ïðîãèçâåä¸ííûõ ïëàòåæåé ïî âûáðàííîìó äëÿ îò÷¸òà ïîëó÷àòåëþ.

Ñóìì2=0, Ñóììà = 0, Ìàñ = 0, x1 = 5

ÍÀ×ÀËÎ

Ïðîäîëæåíèå íà ñòð. 13

Àêòèâèçàöèÿ Ëèñò2 â âûáðàííîì äëÿ îò÷¸òà ôàéëå.

íåò

Len(Ñïèñîê) = 0

äà

MsgBox "Âû íå âûáðàëè íè îäíîãî Ïîëó÷àòåëÿ äëÿ îò÷¸òà"

ßíâàðü = False And Ôåâðàëü = False And Ìàðò = False _

And Àïðåëü = False And Ìàé = False And Èþíü = False _

And Èþëü = False And Àâãóñò = False And Ñåíòÿáðü = False _

And Îêòÿáðü = False And Íîÿáðü = False And Äåêàáðü = False Then

äà

íåò

íåò

íåò

äà

äà

SS = Worksheets(PP).Range("L" & Ñïèñîê.ListIndex + 1)"

MsgBox "Âû íå âûáðàëè íè îäíîãî ìåñÿöà äëÿ îò÷¸òà"

XX = dhExtractString(SS, X, ".")

Do While Len(XX) > 0

Len(XX) = 0

Exit Do

Ïðîäîëæåíèå íà ñòð. 14

Windows("Ïëàò¸æêè" & ÃîäÀêòèâÏë).Activate

N = Worksheets(PP).Cells(XX, 1)

D = Worksheets(PP).Cells(XX, 8)

S = Worksheets(PP).Cells(XX, 7)

K = Worksheets(PP).Cells(XX, 12)

R1 = Month(D) & Year(D)

If (R1 = Ïÿíâàðü & Ãîä) Or (R1 = Ïôåâðàëü & Ãîä) Or (R1 = Ïìàðò & Ãîä) _

Or (R1 = Ïàïðåëü & Ãîä) Or (R1 = Ïìàé & Ãîä) Or (R1 = Ïèþíü & Ãîä) _

Or (R1 = Ïèþëü & Ãîä) Or (R1 = Ïàâãóñò & Ãîä) Or (R1 = Ïñåíòÿáðü & Ãîä) _

Or (R1 = Ïîêòÿáðü & Ãîä) Or (R1 = Ïíîÿáðü & Ãîä) Or (R1 = Ïäåêàáðü & Ãîä) Then

íåò

äà

Ñóììà = Ñóììà + S

Ñóììà2 = Ñóììà2 + 1

Ñòîëáåö

X = X + 1

Loop

Windows("Ïëàò¸æêè" & ÃîäÀêòèâÏë).Activate

Worksheets("Ëèñò2").Range("a1") = Ñïèñîê

Worksheets("Ëèñò2").Range("b" & (Y + 2)) = "Èòîãî:"

Worksheets("Ëèñò2").Range("c" & (Y + 2)) = Ñóììà

Range("A3:I" & Y + 1).Select

Selection.Borders(xlDiagonalDown).LineStyle = xlNone

Selection.Borders(xlDiagonalUp).LineStyle = xlNone

With Selection.Borders(xlEdgeLeft)

.LineStyle = xlContinuous

End With

With Selection.Borders(xlEdgeTop)

.LineStyle = xlContinuous

End With

With Selection.Borders(xlEdgeBottom)

.LineStyle = xlContinuous

End With

With Selection.Borders(xlEdgeRight)

.LineStyle = xlContinuous

End With

With Selection.Borders(xlInsideVertical)

.LineStyle = xlContinuous

End With

"ActiveWorkbook.Save

Range("A1").Select

Ìàñ = Ñóììà & " ðóáëåé."

Ïðîñìîòð.Enabled = True

Ïå÷àòü.Enabled = True

Ñ÷¸ò÷èê.Enabled = True

Windows("Êëèåíòû" & ÃîäÀêòèâÏë).Activate

Label4.Caption = "Îò÷¸ò ïî Ïîëó÷àòåëþ : " & Ñïèñîê _

& ", Ð/Ñ: " & Worksheets(PP).Range("c" & Ñïèñîê.ListIndex + 1) _

& ", Áàíê: " & Worksheets(PP).Range("b" & Ñïèñîê.ListIndex + 1) _

& ", Êîä Áàíê: " & Worksheets(PP).Range("d" & Ñïèñîê.ListIndex + 1) _

& " ñôîðìèðîâàí." _

& " Âñåãî áûëî çà âûáðàííûé ïåðèîä " & Ñóììà2 & " ïëàò¸æåê."

Windows("Ïëàò¸æêè" & ÃîäÀêòèâÏë).Activate

êîíåö

3.4 Ðàçðàáîòêà è òåñòèðîâàíèå ïðîãðàììíîãî ìîäóëÿ.

Âîçì¸ì â êà÷åñòâå òåñòîâîãî ïðèìåðà íåñêîëüêî ïîëó÷àòåëåé ïëàòåæåé . Çàïîëíèì íåêîòîðîå êîë-âî ïëþ ïîðó÷åíèé. Íà ïðèìåð:

Íàèìåíîâàíèå Ïîëó÷àòåëÿ

Äàòà

Êîë-âî ïëàòåæà

Èâàíîâ

01/02/00

500

Èâàíîâ

02/02/00

600

Èâàíîâ

03/03/00

700

Èâàíîâ

04/04/00

800

Èâàíîâ

05/05/00

900

Èâàíîâ

06/06/00

1000

Èâàíîâ

07/07/00

1100

Èâàíîâ

08/08/00

1200

Ñèäîðîâ

01/02/00

100

Ñèäîðîâ

02/02/00

10

Ñèäîðîâ

03/03/00

15

Ñèäîðîâ

04/04/00

16

Ñèäîðîâ

05/05/00

17

Ñèäîðîâ

08/08/00

18

Ñèäîðîâ

08/09/00

19

Èâàíîâ

01/02/00

1000

Èòîãî

7995

Ðåçóëüòàòû ïîëó÷åííûå üâíå ïðîãðàììû ñîâåðøåííî èäåíòè÷íû ðåçóëüòàòàì ïîëó÷åííûì ïðîãðàììûì ïóò¸ì.

Òàê æå ïðîãðàììûé ïðîäóêò ïîäâåðãñÿ òåñòèðîâàíèþ íà ñîáñòâåííîì ïðîèçâîäñòâå. Îøèáîê âûÿâëåíî íå áûëî.

Èç ýòîãî ìîæíî ñäåëàòü âûâîä ÷òî ñîçäàííîå ïðîãðàììíîå îáåñïå÷åíèå ðàáîòàåò ïðàâèëüíî è âïîëíå ãîòîâî ê ýêñïëóàòàöèè.

Çàêëþ÷åíèå.

Ïðåäñòàâëåííûé ïðîãðàììíûé ïðîäóêò ñîçäàí â ñðåäå Excel -97 .

Ïðåèìóùåñòâîì äàííîãî ïðîäóêòà ÿâëÿåòñÿ åãî ïðîñòîòà, äîñòàòî÷íûé êîìôîðò ïðè ýêñïëóàòàöèè, ÷òî äàåò âîçìîæíîñòü ïîëüçîâàòåëþ ýôôåêòèâíî ðàáîòàòü ñ ýòîé ïðîãðàììîé. Êðîìå ýòîãî îáåñïå÷èâàåòñÿ íåïëîõàÿ íàäåæíîñòü ðàáîòû ïðîãðàììíîãî ñðåäñòâà, è õîðîøàÿ èíôîðìàöèîííàÿ íàâèãàöèÿ.

Èçìåíÿåìîñòü ïðîãðàììû ìîæíî îñóùåñòâèòü òîëüêî ìîäåðíèçèðóÿ åå , ÷òî íå ïðåäîñòàâëÿåò äîñòàòî÷íîé ãèáêîñòè.

Ëèòåðàòóðà

  1. “Microsoft OFFICE97 ðàçðàáîòêà ïðèëîæåíèé” Ê.Ñîëîìîí èçäàòåëüñòâî “ÁÕÂ “ ã.Ñàíêò-Ïåòåðáóðã 1998 ãîä.

2. Êåí Ãåòö. Ìàéê Äæèëáåðò ” Ïðîãðàììèðîâàíèå â Microsoft Office “ - èçäàòåëüñòâî “ Ïå÷àòíûé äâîð“ Ãîñóäàðñòâåííîãî êîìèòåòà ÐÔ ïî ïå÷àòè ã.Ñàíêò-Ïåòåðáóðã 1999 ãîä.

3. Ì.ÌàêÊåëâè è äð. “ Visual Basic 5 “ èçäàòåëüñòâî “ BHV-Ñàíêò-Ïåòåðáóðã“ 1998 ãîä.

4. Ð.Ïåðñîí. “Excel äëÿ Windows 95 “ èçäàòåëüñòâî “ BHV-Ñàíêò-Ïåòåðáóðã“ 1998 ãîä.

5. Ð.Âèíòåð. “Microsoft Office äëÿ Windows 95 “ èçäàòåëüñòâî “ BHV-Ñàíêò-Ïåòåðáóðã“ 1998 ãîä.

6. Ôèãóðíîâ Â.Ý.” IBM PC äëÿ ïîëüçîâàòåëÿ.” - Ì: Ôèíàíñû è ñòàòèñòèêà, 1991.

7.×.Ïåòçîëä “Ïðîãðàììèðîâàíèå äëÿ Windows 95 ” èçäàòåëüñòâî “ BHV-Ñàíêò-Ïåòåðáóðã“ 1998 ãîä.

8 . Ô. Íîâèêîâ,À.ßöåíêî. “Microsoft Office â öåëîì” èçäàòåëüñòâî “ BHV-Ñàíêò-Ïåòåðáóðã“ 1998 ãîä.

Èñõîäíûé òåêñò îñíîâíîãî ïðîãðàììíîãî ìîäóëÿ.

Dim ¹ÏË As String

Dim Ïëàòÿùèé As String

Dim BOX

Dim ÁÎÊÑ

Dim ÌÏ1 As String

Dim Ãîä

Private Sub ComboBox1_Change()

Windows("Êëèåíòû" & Year(Date)).Activate

If ComboBox1.ListIndex = -1 Then

Exit Sub

End If

a = ComboBox1.ListIndex

Ñ÷¸ò÷èê2.Visible = False

Ñîçäàòü.Visible = False

Ïðåäîñìîòð.Visible = False

ÑîõðàíèòüÍîâ.Visible = True

If Len(Worksheets(¹ÏË).Range("A1")) = 0 Then

ComboBox1.Visible = False

Windows("Êëèåíòû" & Year(Date)).Activate

Ñ÷¸ò = Worksheets(¹ÏË).Range("C1")

Áàíê = Worksheets(¹ÏË).Range("B1")

Êëèåíò = Worksheets(¹ÏË).Range("A1")

ÊîäÁàíêà = Worksheets(¹ÏË).Range("D1")

ÓÍÍ = Worksheets(¹ÏË).Range("E1")

ÂèäÎïåðàöèè = Worksheets(¹ÏË).Range("f1")

Íàçíà÷Ïëàòåæà1 = Worksheets(¹ÏË).Range("g1")

ÍîìÍàçÏë = Worksheets(¹ÏË).Range("H1")

ElseIf a < 0 Then

ComboBox1.ListIndex = a + 1

Windows("Êëèåíòû" & Year(Date)).Activate

Ñ÷¸ò = (Worksheets(¹ÏË).Range("C" & (ComboBox1.ListIndex + 1)))

Áàíê = (Worksheets(¹ÏË).Range("B" & (ComboBox1.ListIndex + 1)))

Êëèåíò = (Worksheets(¹ÏË).Range("A" & (ComboBox1.ListIndex + 1)))

ÊîäÁàíêà = (Worksheets(¹ÏË).Range("D" & (ComboBox1.ListIndex + 1)))

ÓÍÍ = (Worksheets(¹ÏË).Range("E" & (ComboBox1.ListIndex + 1)))

ÂèäÎïåðàöèè = Worksheets(¹ÏË).Range("f" & (ComboBox1.ListIndex + 1))

Íàçíà÷Ïëàòåæà1 = Worksheets(¹ÏË).Range("g" & (ComboBox1.ListIndex + 1))

ÍîìÍàçÏë = Worksheets(¹ÏË).Range("H" & (ComboBox1.ListIndex + 1))

Else

Windows("Êëèåíòû" & Year(Date)).Activate

Ñ÷¸ò = (Worksheets(¹ÏË).Range("C" & (ComboBox1.ListIndex + 1)))

Áàíê = (Worksheets(¹ÏË).Range("B" & (ComboBox1.ListIndex + 1)))

Êëèåíò = (Worksheets(¹ÏË).Range("A" & (ComboBox1.ListIndex + 1)))

ÊîäÁàíêà = (Worksheets(¹ÏË).Range("D" & (ComboBox1.ListIndex + 1)))

ÓÍÍ = (Worksheets(¹ÏË).Range("E" & (ComboBox1.ListIndex + 1)))

ÂèäÎïåðàöèè = Worksheets(¹ÏË).Range("f" & (ComboBox1.ListIndex + 1))

Íàçíà÷Ïëàòåæà1 = Worksheets(¹ÏË).Range("g" & (ComboBox1.ListIndex + 1))

ÍîìÍàçÏë = Worksheets(¹ÏË).Range("H" & (ComboBox1.ListIndex + 1))

End If

End Sub

Private Sub Âûõîä_Click()

Windows("Ïëàò¸æêè" & Year(Date)).Activate

ActiveWorkbook.Save

ActiveWindow.Close

Windows("Êëèåíòû" & Year(Date)).Activate

ActiveWorkbook.Save

ActiveWindow.Close

Windows("Ïëàò¸æêà.xls").Activate

ActiveWorkbook.Save

ActiveWindow.Close

Application.Quit

"ActiveWorkbook.RunAutoMacros Which:=xlAutoClose

End Sub

Private Sub UserForm_Activate()

Windows("Ïëàò¸æêà.xls").Activate

Ïëàòÿùèé = "Òåêóùèé Ïëàòåëüùèê : " & Worksheets("Ëèñò1").Range("E7") & _

" ÓÍÍ : " & Worksheets("Ëèñò1").Range("C7") & _

" P/c : " & Worksheets("Ëèñò1").Range("Q8") & _

" Áàíê : " & Worksheets("Ëèñò1").Range("D8") & _

" Êîä Áàíêà : " & Worksheets("Ëèñò1").Range("P9")

¹ÏË = Worksheets("Ëèñò1").Range("A1")

Windows("Êëèåíòû" & Year(Date)).Activate

ComboBox1.Clear

ÌÏ = True

X = 1

Ãîä = Year(Date)

While Len(Worksheets(¹ÏË).Range("A" & X)) <> 0

ComboBox1.AddItem (Worksheets(¹ÏË).Range("A" & X))

X = X + 1

Wend

End Sub

Private Sub ÇàÏðîøëûéÃîä_Click()

If Dir("C:Program FilesÏëàò¸æêàÏëàò¸æêè" & (Year(Date) - 1) & ".xls") = _

"Ïëàò¸æêè" & (Year(Date) - 1) & ".xls" Then

Workbooks.Open FileName:="C:Program FilesÏëàò¸æêàÏëàò¸æêè" & (Year(Date) - 1)

Windows("Ïëàò¸æêè" & (Year(Date) - 1)).Activate

Worksheets(¹ÏË).Select

Ãîä = Year(Date) - 1

Else

ÁÎÊÑ = MsgBox("Çà ïðîøëûé ãîä ôàéë îò÷¸òà íå íàéäåí", , BOX)

Exit Sub

End If

Âêîíåö = True

End Sub

Private Sub Ïëàòåëüùèêè_Click()

UserForm1.Hide

UserForm3.Show

End Sub

Private Sub Îò÷¸òû_Click()

UserForm1.Hide

UserForm2.Show

End Sub

Private Sub Ìèíóñ_Click() " îòíèìàåò 1 äåíü îò äàòû

If IsDate(Äàòà) = True Then

Äàòà = CDate(Äàòà) - 1

Else

End If

End Sub

Private Sub Ïëþñ_Click() " ïðèáàâëÿåò îäèí äåíü ê äàòå

If IsDate(Äàòà) = True Then

Äàòà = CDate(Äàòà) + 1

Else

End If

End Sub

Private Sub Ïðåäîñìîòð_Click() " àêòèâèçèðóåò îêíî ïðîñìîòðà Excel

Windows("Ïëàò¸æêà.xls").Activate

Application.Visible = True

UserForm1.Hide

ActiveWindow.SelectedSheets.PrintPreview

Application.Visible = False

UserForm1.Show

End Sub

Private Sub UserForm_Initialize()

If Dir("C:Program FilesÏëàò¸æêàÊëèåíòû" & Year(Date) & ".xls") <> _

"Êëèåíòû" & Year(Date) & ".xls" Then

Workbooks.Open FileName:="C:Program FilesÏëàò¸æêàÊëèåíòû" & (Year(Date) - 1)

Windows("Êëèåíòû" & (Year(Date) - 1)).Activate

ActiveWorkbook.SaveAs FileName:="C:Program FilesÏëàò¸æêàÊëèåíòû" & Year(Date)

Workbooks.Open FileName:="C:Program FilesÏëàò¸æêàÏëàò¸æêè" & (Year(Date) - 1)

Windows("Ïëàò¸æêè" & (Year(Date) - 1)).Activate

ActiveWorkbook.SaveAs FileName:="C:Program FilesÏëàò¸æêàÏëàò¸æêè" & Year(Date)

Workbooks.Open FileName:="C:Program FilesÏëàò¸æêàÏëàòåëüùèêè.xls"

Windows("Ïëàòåëüùèêè.xls").Activate

X = 1

Do While Len(Worksheets("Ëèñò1").Range("A" & X)) <> 0

X = X + 1

Loop

X = X - 1

Do While X <> 0

Windows("Êëèåíòû" & Year(Date)).Activate

Worksheets(CStr(X)).Select

Worksheets(CStr(X)).Range("L1:L65535").Select

Selection.ClearContents

Windows("Ïëàò¸æêè" & Year(Date)).Activate

Worksheets(CStr(X)).Select

Worksheets(CStr(X)).Columns("A:AG").Select

Selection.ClearContents

X = X - 1

Loop

Windows("Êëèåíòû" & Year(Date)).Activate

ActiveWorkbook.Save

Windows("Ïëàò¸æêè" & Year(Date)).Activate

ActiveWorkbook.Save

Workbooks.Open FileName:="C:Program FilesÏëàò¸æêàÏëàò¸æêà.xls"

Windows("Ïëàòåëüùèêè.xls").Activate

Worksheets("Ãîäà").Select

X = 1

While Len(Worksheets("Ãîäà").Range("A" & X)) <> 0

X = X + 1

Wend

"Worksheets("Ãîäà").Range("A" & X) = CStr((Year(Date) - 1))

Worksheets("Ãîäà").Range("A" & X) = CStr(Year(Date))

ActiveWorkbook.Save

Else

Workbooks.Open FileName:="C:Program FilesÏëàò¸æêàÊëèåíòû" & Year(Date)

Workbooks.Open FileName:="C:Program FilesÏëàò¸æêàÏëàò¸æêè" & Year(Date)

Workbooks.Open FileName:="C:Program FilesÏëàò¸æêàÏëàò¸æêà.xls"

Workbooks.Open FileName:="C:Program FilesÏëàò¸æêàÏëàòåëüùèêè.xls"

End If

Ãîä = Year(Date)

Ñ÷¸ò÷èê2.List = Array(1, 2, 3)

Ñ÷¸ò÷èê2 = 1

Äàòà = Date

ÌÏ = True

ComboBox1.Visible = True

ÍîìåðÏë.Visible = False

Label1.Visible = True

Ñîçäàòü.Visible = False

Label14.Visible = False

Ñ÷¸ò÷èê.Visible = False

ÊÑòàðÏë.Visible = False

Ïðåäîñìîòð.Visible = False

Ñ÷¸ò÷èê2.Visible = False

ÈçìåíåíèÿÑÒ.Visible = False

Âêîíåö.Visible = False

íîìåðÑÒÏË.Visible = False

ÏîÍîìåðó.Visible = False

ÇàÏðîøëûéÃîä.Visible = False

Ñåãîäíÿ.Caption = "Ñåãîäíÿ : " & Date

BOX = "Ïëàò¸æêà"

Windows("Ïëàò¸æêà.xls").Activate

¹ÏË = Worksheets("Ëèñò1").Range("a1")

Windows("Êëèåíòû" & Year(Date)).Activate

X = 1

While Len(Worksheets(¹ÏË).Range("A" & X)) <> 0

ComboBox1.AddItem (Worksheets(¹ÏË).Range("A" & X))

X = X + 1

Wend

End Sub

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

Windows("Ïëàò¸æêè" & Year(Date)).Activate

ActiveWorkbook.Save

ActiveWindow.Close

Windows("Êëèåíòû" & Year(Date)).Activate

ActiveWorkbook.Save

ActiveWindow.Close

Windows("Ïëàò¸æêà.xls").Activate

ActiveWorkbook.Save

ActiveWindow.Close

Application.Quit

"ActiveWorkbook.RunAutoMacros Which:=xlAutoClose

End Sub

Private Sub Èçìåíèíèÿ_Click()

Windows("Êëèåíòû" & Year(Date)).Activate

If Ïðîâåðêà = False Then " Ïðîâåðêà íà ïðàâèëüíîñòü " ôóíêöèÿ íàõîäèòñÿ â êîíöå ïðîãðàììû

Exit Sub " ââåä¸ííîé èíôîðìàö

Else " ôóíêöèÿ íàõîäèòñÿ â êîíöå ïðîãðàììû

End If

X = 1

Do While X < ComboBox1.ListCount + 1

If Êëèåíò = Worksheets(¹ÏË).Range("A" & X) _

And Áàíê = Worksheets(¹ÏË).Range("b" & X) _

And Ñ÷¸ò = Worksheets(¹ÏË).Range("c" & X) _

And ÊîäÁàíêà = Worksheets(¹ÏË).Range("d" & X) _

And ÓÍÍ = Worksheets(¹ÏË).Range("e" & X) _

And ÂèäÎïåðàöèè = Worksheets(¹ÏË).Range("f" & X) _

And ÍîìÍàçÏë = Worksheets(¹ÏË).Range("H" & X) _

And Íàçíà÷Ïëàòåæà1 = Worksheets(¹ÏË).Range("g" & ComboBox1.ListIndex + 1) _

Then

ÁÎÊÑ = MsgBox("Èçâåíèòå íî : " & Êëèåíò & " óæå åñòü â ñïèñêå Ïîëó÷àòåëåé." _

& Chr(10) & "Ïîïðîáóéòå âûáðàòü Ïîëó÷àòåëÿ èç ñïèñêà.", , BOX)

Exit Sub

Else

X = X + 1

End If

Loop

Worksheets(¹ÏË).Range("A" & (ComboBox1.ListIndex + 1)) = Êëèåíò

Worksheets(¹ÏË).Range("b" & (ComboBox1.ListIndex + 1)) = Áàíê

Worksheets(¹ÏË).Range("c" & (ComboBox1.ListIndex + 1)) = Ñ÷¸ò

Worksheets(¹ÏË).Range("d" & (ComboBox1.ListIndex + 1)) = ÊîäÁàíêà

Worksheets(¹ÏË).Range("e" & (ComboBox1.ListIndex + 1)) = ÓÍÍ

Worksheets(¹ÏË).Range("f" & (ComboBox1.ListIndex + 1)) = ÂèäÎïåðàöèè

Worksheets(¹ÏË).Range("g" & (ComboBox1.ListIndex + 1)) = Íàçíà÷Ïëàòåæà1

Worksheets(¹ÏË).Range("H" & (ComboBox1.ListIndex + 1)) = ÍîìÍàçÏë

ActiveWorkbook.Save

ÁÎÊÑ = MsgBox("Èçìåíåíèÿ â äàííûå î Êëèåíòå : " & Êëèåíò & " óñïåøíî âíåñ¸íû â ñïèñîê êëèåíòîâ", , BOX)

Êëèåíò.SetFocus

End Sub

Private Sub ÄîáàâèòüÏîë_Click()

Windows("Êëèåíòû" & Year(Date)).Activate

If Ïðîâåðêà = False Then " Ïðîâåðêà íà ïðàâèëüíîñòü " ôóíêöèÿ íàõîäèòñÿ â êîíöå ïðîãðàììû

Exit Sub " ââåä¸ííîé èíôîðìàö

Else " ôóíêöèÿ íàõîäèòñÿ â êîíöå ïðîãðàììû

End If

X = 1

Do While X < ComboBox1.ListCount + 1

If Êëèåíò = Worksheets(¹ÏË).Range("A" & X) _

And Áàíê = Worksheets(¹ÏË).Range("b" & X) _

And Ñ÷¸ò = Worksheets(¹ÏË).Range("c" & X) _

And ÊîäÁàíêà = Worksheets(¹ÏË).Range("d" & X) _

And ÓÍÍ = Worksheets(¹ÏË).Range("e" & X) _

And ÂèäÎïåðàöèè = Worksheets(¹ÏË).Range("f" & X) _

And ÍîìÍàçÏë = Worksheets(¹ÏË).Range("H" & X) _

Then

ÁÎÊÑ = MsgBox("Èçâåíèòå íî : " & Êëèåíò & " óæå åñòü â ñïèñêå Ïîëó÷àòåëåé." _

& Chr(10) & "Ïîïðîáóéòå âûáðàòü Ïîëó÷àòåëÿ èç ñïèñêà.", , BOX)

Exit Sub

Else

X = X + 1

End If

Loop

X = 1

While Len(Worksheets(¹ÏË).Range("A" & X)) <> 0

X = X + 1

Wend

Worksheets(¹ÏË).Range("A" & X) = Êëèåíò

Worksheets(¹ÏË).Range("b" & X) = Áàíê

Worksheets(¹ÏË).Range("c" & X) = Ñ÷¸ò

Worksheets(¹ÏË).Range("d" & X) = ÊîäÁàíêà

Worksheets(¹ÏË).Range("e" & X) = ÓÍÍ

Worksheets(¹ÏË).Range("f" & X) = ÂèäÎïåðàöèè

Worksheets(¹ÏË).Range("g" & X) = Íàçíà÷Ïëàòåæà1

Worksheets(¹ÏË).Range("H" & X) = ÍîìÍàçÏë

ComboBox1.Visible = True

ComboBox1.AddItem (Worksheets(¹ÏË).Range("A" & (ComboBox1.ListCount + 1)))

ComboBox1.ListIndex = X - 1

ActiveWorkbook.Save

ÁÎÊÑ = MsgBox("Íîâûé Êëèåíò : " & Êëèåíò & " âíåñ¸í â ñïèñîê êëèåíòîâ", , BOX)

Êëèåíò.SetFocus

End Sub

Private Sub ÊÑòàðÏë_Click()

Windows("Ïëàò¸æêà.xls").Activate

If Len(ÍîìåðÏë) = 0 Then

ÁÎÊÑ = MsgBox("Âû íå âûáðàëè ïëàò¸æêó...", , BOX)

Exit Sub

Else

End If

If ÏðîâåðêàÏË = False Then " Ïðîâåðêà íà ïðàâèëüíîñòü

Exit Sub " ââåä¸ííîé èíôîðìàöèè

Else " ôóíêöèÿ íàõîäèòñÿ â êîíöå ïðîãðàììû

End If

Âïëàò¸æêó "ôóíêöèÿ ñîõðàíÿþùàÿ äàííûå â ïëàò¸æêå

ActiveWorkbook.Save

Windows("Ïëàò¸æêè" & Year(Date)).Activate

Worksheets(¹ÏË).Range("A" & ÍîìåðÏë) = ÍîìåðÏë

Worksheets(¹ÏË).Range("c" & ÍîìåðÏë) = Áàíê

Worksheets(¹ÏË).Range("d" & ÍîìåðÏë) = Ñ÷¸ò

Worksheets(¹ÏË).Range("b" & ÍîìåðÏë) = Êëèåíò

Worksheets(¹ÏË).Range("e" & ÍîìåðÏë) = ÊîäÁàíêà

Worksheets(¹ÏË).Range("f" & ÍîìåðÏë) = ÓÍÍ

Worksheets(¹ÏË).Range("g" & ÍîìåðÏë) = Äåíüãè

Worksheets(¹ÏË).Range("h" & ÍîìåðÏë) = Äàòà

Worksheets(¹ÏË).Range("I" & ÍîìåðÏë) = ÄàòàÓñëóã

Worksheets(¹ÏË).Range("J" & ÍîìåðÏë) = ÂèäÎïåðàöèè

Worksheets(¹ÏË).Range("K" & ÍîìåðÏë) = Íàçíà÷Ïëàòåæà1

Worksheets(¹ÏË).Range("L" & ÍîìåðÏë) = ÍîìÍàçÏë

Worksheets(¹ÏË).Range("M" & ÍîìåðÏë) = ÌÏ1

Windows("Ïëàò¸æêà.xls").Activate

Âïå÷àòü "ôóíêöèÿ ïå÷àòè

End Sub

Private Sub ÈçìåíåíèÿÑÒ_Click()

If Year(Äàòà) <> Ãîä Then

ÁÎÊÑ = MsgBox("Â äàòå äîëæåí ñòîÿòü " & Ãîä & " ãîä", , BOX)

Exit Sub

End If

Windows("Ïëàò¸æêà.xls").Activate

If Len(ÍîìåðÏë) = 0 Then

ÁÎÊÑ = MsgBox("Âû íå âûáðàëè ïëàò¸æêó...", , BOX)

Exit Sub

Else

End If

If ÏðîâåðêàÏË = False Then " Ïðîâåðêà íà ïðàâèëüíîñòü

Exit Sub " ââåä¸ííîé èíôîðìàöèè

Else " ôóíêöèÿ íàõîäèòñÿ â êîíöå ïðîãðàììû

End If

Âïëàò¸æêó "ôóíêöèÿ ñîõðàíÿþùàÿ äàííûå â ïëàò¸æêå

ActiveWorkbook.Save

Windows("Ïëàò¸æêè" & Ãîä).Activate

Worksheets(¹ÏË).Range("A" & ÍîìåðÏë) = ÍîìåðÏë

Worksheets(¹ÏË).Range("c" & ÍîìåðÏë) = Áàíê

Worksheets(¹ÏË).Range("d" & ÍîìåðÏë) = Ñ÷¸ò

Worksheets(¹ÏË).Range("b" & ÍîìåðÏë) = Êëèåíò

Worksheets(¹ÏË).Range("e" & ÍîìåðÏë) = ÊîäÁàíêà

Worksheets(¹ÏË).Range("f" & ÍîìåðÏë) = ÓÍÍ

Worksheets(¹ÏË).Range("g" & ÍîìåðÏë) = CDbl(Äåíüãè)

Worksheets(¹ÏË).Range("h" & ÍîìåðÏë) = Äàòà

Worksheets(¹ÏË).Range("I" & ÍîìåðÏë) = ÄàòàÓñëóã

Worksheets(¹ÏË).Range("J" & ÍîìåðÏë) = ÂèäÎïåðàöèè

Worksheets(¹ÏË).Range("K" & ÍîìåðÏë) = Íàçíà÷Ïëàòåæà1

Worksheets(¹ÏË).Range("L" & ÍîìåðÏë) = ÍîìÍàçÏë

Worksheets(¹ÏË).Range("M" & ÍîìåðÏë) = ÌÏ1

ActiveWorkbook.Save

ÁÎÊÑ = MsgBox("Èçìåíåíèÿ â ïëàò¸æêó ¹: " & ÍîìåðÏë & " óñïåøíî âíåñ¸íû ", , BOX)

Êëèåíò.SetFocus

End Sub

Private Sub Ñåãîäíÿ_Click()

Äàòà = Date

End Sub

Private Sub ÑòàðûåÏë_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

If ÑòàðûåÏë = False Then

Label16.Caption = " Íàæàâ íà ýòó êíîïêó Âû ìîæåòå ïîñìîòðåòü âñå Âàøè ñòàðîì ïëàò¸æêè" _

& " à òàê-æå ÷òî-òî ïîäïðàâèòü è ñîõðàíèòü ýòè èçìåíåíèÿ"

Else

Label16.Caption = " Íàæàâ íà ýòó êíîïêó Âû ïåðåéä¸òå ê ôîðìå ôîðìèðîâàíèÿ ïëàò¸æåê"

End If

End Sub

Private Sub Îò÷¸òû_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Êíîïêà "Îò÷¸òû" äëÿ ïåðåõîäà â ôîðìó ÎÒרÒÛ. Òàì Âû ñìîæåòå óçíàòü êóäà æå äåëèñü Âàøè äåíüãè !!!"

End Sub

Private Sub Âûõîä_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Êíîïêà "Âûõîä" äëÿ âûõîäà èç ïðîãðàììû. Åñëè ðåøèëè âûéòè ñìåëî æìèòå, ïðîãðàììà ñîõðàíèò ðåçóëüòàòû âàøåé ðàáîòû."

End Sub

Private Sub ÓáèòüÊëèåíòà_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = " Íàæàâ íà ýòó êíîïêó Âû ìîæåòå óäàëèòü âûáðàííîãî Ïîëó÷àòåëÿ èç ñïèñêà Ïîëó÷àòåëåé "

End Sub

Private Sub ÏîÍîìåðó_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = " Ââåäèòå íîìåð ïëàò¸æêè â ðàñïîëîæåííîå ðÿäîì ñ ýòîé êíîïêîé íåáîëüøîå ïîëå. Çàòåì íàæìèòå íà ýòó êíîïêó è âû ïåðåéä¸òå ê ïëàò¸æêå ñ ââåä¸ííûì âàìè íîìåðîì. "

End Sub

Private Sub Âêîíåö_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = " Íàæàâ íà ýòó êíîïêó Âû îñóùåñòâèòå ïåðåõîä ê êîíöó ñïèñêà ïëàò¸æåê "

End Sub

Private Sub Èçìåíèíèÿ_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = " Íàæàâ íà ýòó êíîïêó Âû âíåñ¸òå èçìåíåíèÿ â ñïèñîê Ïîëó÷àòåëåé "

End Sub

Private Sub ÄîáàâèòüÏîë_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = " Íàæàâ íà ýòó êíîïêó Âû âíåñ¸òå â ñïèñîê Ïîëó÷àòåëåé Âàøèõ äåíåã äàííûå î íîâîì Ïîëó÷àòåëå "

End Sub

Private Sub ÈçìåíåíèÿÑÒ_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = " Íàæàâ íà ýòó êíîïêó Âû ìîæåòå ñîõðàíèòü èçìåíåíèÿ â ñòàðîì ïëàò¸æíîì ïîðó÷åíèè"

End Sub

Private Sub ÊÑòàðÏë_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = " Íàæàâ íà ýòó êíîïêó Âû ìîæåòå ðàñïå÷àòàòü Âàøå ñòàðîå ïëàò¸æíîå ïîðó÷åíèÿ" _

& " Íå çàáóäüòå âûáðàòü êîë-âî êîïèé â âûïàäàþùåì ñïèñêå ðÿäîì ñ êíîïêîé"

End Sub

Private Sub ÑîõðàíèòüÍîâ_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Ýòà êíîïêà ïðåäíàçíà÷åíà äëÿ ñîõðàíåíèÿ ñîçäàííîãî ïëàò¸æíîãî ïîðó÷åíèÿ"

End Sub

Private Sub Ñîçäàòü_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Íàæàâ íà ýòó êíîïêó Âû ìîæåòå ðàñïå÷àòàòü Âàøå ïëàò¸æíîå ïîðó÷åíèÿ" _

& " Íå çàáóäüòå âûáðàòü êîë-âî êîïèé â âûïàäàþùåì ñïèñêå ðÿäîì ñ êíîïêîé"

End Sub

Private Sub UserForm_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = Ïëàòÿùèé

End Sub

Private Sub Ïëàòåëüùèêè_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Íàæàâ ýòó êíîïêà Âû ìîæåòå ïîìåíÿòü òåêóùåãî Ïëàòåëüùèêà èëè âíåñòè èçìåíåíèÿ â ñóùåñòâóþùèå äàííûå î Ïëàòåëüùèêå"

End Sub

Private Sub Ñåãîäíÿ_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Êíîïêà äëÿ âñòàâêè òåêóùåé äàòû â ôîðìèðóåìóþ ïëàò¸æêó"

End Sub

Private Sub ÊîäÁàíêà_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò êîä áàíêà Ïîëó÷àòåëÿ. Äîïóñêàþòñÿ òîëüêî öèôðîâûå çíà÷åíèÿ."

End Sub

Private Sub ComboBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "×òî áû âñòàâèòü äàííûå Ïîëó÷àòåëÿ ïëàòåæà âîñòîëüçóéòåñü ýòèì âûïàäàþùåì ñïèñêîì. Åñëè äàííûå îòñóòñòâóþò, çíà÷èò ïðèä¸òñÿ äîáàâèòü íîâîãî Ïîëó÷àòåëÿ."

End Sub

Private Sub Label14_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Íîìåð òåêóùåé ïëàò¸æêè"

End Sub

Private Sub Äàòà_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò äàòó ôîðìèðóåìîé ïëàò¸æêè. Äîïóñêàþòñÿ òàêèå ôîðìàòû äàò. Ïðèìåð : 01,01,200 èëè 01/01/2000 èëè 01.01/00"

End Sub

Private Sub ÓÍÍ_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "ÍÅ îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò ÓÍÍ Ïîëó÷àòåëÿ. Äîïóñêàþòñÿ òîëüêî öèôðîâûå çíà÷åíèÿ."

End Sub

Private Sub Íàçíà÷Ïëàòåæà1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Îáÿçàòåëüíîå ïîëå. Â ýòî ïîëå âíîñÿò ñâåäåíèÿ çà ÷òî Âû ñîáñòâåííî ïëàòèòå." _

& "ÑÎÂÅÒ åñëè Âû çíàåòå,÷òî áóäåòå çäåñü ïèñàòü ïî÷òè âñåãäà îäíî è òîæå " _

& "òî íàæìèòå êíîïêó Âíåñòè èçìåíåíèÿ â äàííûå î Ïîëó÷àòåëå."

End Sub

Private Sub Êëèåíò_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò Íàèìåíîâàíèå Ïîëó÷àòåëÿ. Íà ïðèìåð: ""ÎÎÎ Ïðèÿòíûå Ìåëî÷è"""

End Sub

Private Sub Áàíê_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò Íàèìåíîâàíèå Áàíêà Ïîëó÷àòåëÿ. Íà ïðèìåð: ""ÎÀÎ Áåëáèçíåñáàíê ã. Ìîãèë¸â"""

End Sub

Private Sub Ñ÷¸ò_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò ¹ ðàñ÷¸òíîãî ñ÷¸òà Ïîëó÷àòåëÿ. Äîïóñêàþòñÿ òîëüêî öèôðîâûå çíà÷åíèÿ."

End Sub

Private Sub ÄàòàÓñëóã_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "ÍÅ îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò äàòó ïîëó÷åíèÿ òîâàðà èëè îêàçàíèÿ óñëóã. Ïðèìåð: Ïðåäîïëàòà èëè 28 ìàðòà 2000ã."

End Sub

Private Sub ÂèäÎïåðàöèè_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "ÍÅ îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò ÷èñëî îòðàæàþùåå âèä îïåðàöèè. Äîïóñêàþòñÿ òîëüêî öèôðîâûå çíà÷åíèÿ."

End Sub

Private Sub ÍîìÍàçÏë_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "ÍÅ îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò ÷èñëî îòðàæàþùåå êîä íàçíà÷åíèÿ ïëàòåæà. Äîïóñêàþòñÿ òîëüêî öèôðîâûå çíà÷åíèÿ."

End Sub

Private Sub Äåíüãè_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Îáÿçàòåëüíîå ïîëå.  ýòî ïîëå âíîñÿò ñóììó ïëàòåæà. Äîïóñêàþòñÿ òîëüêî öèôðîâûå çíà÷åíèÿ."

End Sub

Private Sub Ìèíóñ_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Îòíèìàåò îäèí äåíü îò òåêóùåé äàòû."

End Sub

Private Sub Ïëþñ_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)

Label16.Caption = "Äîáàâëÿåò îäèí äåíü ê òåêóùåé äàòå."

End Sub

Private Sub ÑîõðàíèòüÍîâ_Click()

If Year(Äàòà) <> Year(Date) Then

ÁÎÊÑ = MsgBox("Èçâèíèòå íî â ñòðîêå "Äàòà" îøèáêà. Óêàæèòå òåêóùèé Ãîä", , BOX)

Äàòà.SetFocus

Exit Sub

End If

Windows("Ïëàò¸æêà.xls").Activate

If ÏðîâåðêàÏË = False Then " Ïðîâåðêà íà ïðàâèëüíîñòü

Exit Sub " ââåä¸ííîé èíôîðìàöèè

Else " ôóíêöèÿ íàõîäèòñÿ â êîíöå ïðîãðàììû

End If

If ComboBox1.ListIndex = -1 Then

ÁÎÊÑ = MsgBox("Èçâèíèòå íî Âû çàáûëè âíåñòè Ïîëó÷àòåëÿ : " & Êëèåíò & " â ñïèñîê Ïîëó÷àòåëåé ", , BOX)

Exit Sub

Else

End If

Windows("Êëèåíòû" & Year(Date)).Activate

If Êëèåíò <> ComboBox1 _

Or Ñ÷¸ò <> Worksheets(¹ÏË).Range("c" & ComboBox1.ListIndex + 1) _

Or Áàíê <> Worksheets(¹ÏË).Range("b" & ComboBox1.ListIndex + 1) _

Or ÊîäÁàíêà <> Worksheets(¹ÏË).Range("d" & ComboBox1.ListIndex + 1) _

Or ÓÍÍ <> Worksheets(¹ÏË).Range("e" & ComboBox1.ListIndex + 1) _

Or ÂèäÎïåðàöèè <> Worksheets(¹ÏË).Range("f" & ComboBox1.ListIndex + 1) _

Or ÍîìÍàçÏë <> Worksheets(¹ÏË).Range("H" & ComboBox1.ListIndex + 1) _

Then

ÁÎÊÑ = MsgBox("Èçâèíèòå íî Âû çàáûëè âíåñòè Ïîëó÷àòåëÿ : " & Êëèåíò & " â ñïèñîê Ïîëó÷àòåëåé ", , BOX)

Exit Sub

Else

End If

Ñ÷¸ò÷èê2.Visible = True

Ïðåäîñìîòð.Visible = True

Âïëàò¸æêó "ôóíêöèÿ ñîõðàíÿþùàÿ äàííûå â ïëàò¸æêå

ActiveWorkbook.Save

Windows("Ïëàò¸æêè" & Year(Date)).Activate

ÑîõðàíèòüÍîâ.Visible = False

Ñîçäàòü.Visible = True

X = 1

While Len(Worksheets(¹ÏË).Range("A" & X)) <> 0

X = X + 1

Wend

Worksheets(¹ÏË).Select

Range("A" & X).Select

Selection.NumberFormat = "#,##0"

Worksheets(¹ÏË).Range("A" & X) = X

Range("g" & X).Select

Selection.NumberFormat = "#,##0"

Worksheets(¹ÏË).Range("g" & X) = CDbl(Äåíüãè)

Worksheets(¹ÏË).Range("c" & X) = Áàíê

Worksheets(¹ÏË).Range("d" & X) = Ñ÷¸ò

Worksheets(¹ÏË).Range("b" & X) = Êëèåíò

Worksheets(¹ÏË).Range("e" & X) = ÊîäÁàíêà

Worksheets(¹ÏË).Range("f" & X) = ÓÍÍ

Worksheets(¹ÏË).Range("h" & X) = Äàòà

Worksheets(¹ÏË).Range("I" & X) = ÄàòàÓñëóã

Worksheets(¹ÏË).Range("J" & X) = ÂèäÎïåðàöèè

Worksheets(¹ÏË).Range("K" & X) = Íàçíà÷Ïëàòåæà1

Worksheets(¹ÏË).Range("L" & X) = ÍîìÍàçÏë

Worksheets(¹ÏË).Range("M" & X) = ÌÏ1

Windows("Ïëàò¸æêà.xls").Activate

Worksheets("Ëèñò1").Range("O2") = X

Windows("Êëèåíòû" & Year(Date)).Activate

Worksheets(¹ÏË).Range("L" & ComboBox1.ListIndex + 1).NumberFormat = "@"

Worksheets(¹ÏË).Range("L" & ComboBox1.ListIndex + 1) = _

Worksheets(¹ÏË).Range("L" & ComboBox1.ListIndex + 1) + "" & X & "."

ActiveWorkbook.Save

Windows("Ïëàò¸æêè" & Year(Date)).Activate

ActiveWorkbook.Save

End Sub

Private Sub ÑòàðûåÏë_Click()

If ÑòàðûåÏë.Value = True Then

ComboBox1.Visible = False

ÍîìåðÏë.Visible = True

Label1.Visible = False

Label14.Visible = True

Ñ÷¸ò÷èê.Visible = True

Ñ÷¸ò÷èê.SetFocus

ÊÑòàðÏë.Visible = True

Ñîçäàòü.Visible = False

Èçìåíèíèÿ.Visible = False

ÄîáàâèòüÏîë.Visible = False

ÓáèòüÊëèåíòà.Visible = False

ÑîõðàíèòüÍîâ.Visible = False

ÇàÏðîøëûéÃîä.Visible = True

Ñ÷¸ò÷èê2.Visible = True

Ïðåäîñìîòð.Visible = True

ÈçìåíåíèÿÑÒ.Visible = True

Âêîíåö.Visible = True

íîìåðÑÒÏË.Visible = True

ÏîÍîìåðó.Visible = True

ÑòàðûåÏë.Caption = "Âåðíóòüñÿ ê ñîçäàíèþ ïëàò¸æåê"

Ñ÷¸ò÷èê = 0

Ñ÷¸ò = ""

Áàíê = ""

Êëèåíò = ""

ÊîäÁàíêà = ""

ÓÍÍ = ""

ÂèäÎïåðàöèè = ""

Íàçíà÷Ïëàòåæà1 = ""

ÍîìÍàçÏë = ""

ÍîìåðÏë = ""

Äàòà = ""

Äåíüãè = ""

ÄàòàÓñëóã = ""

Else

If Ãîä <> Year(Date) Then

Windows("Ïëàò¸æêè" & Ãîä).Activate

ActiveWindow.Close

Ãîä = Year(Date)

Else

End If

Äàòà = Date

Ñ÷¸ò = ""

Áàíê = ""

Êëèåíò = ""

ÊîäÁàíêà = ""

ÓÍÍ = ""

ÂèäÎïåðàöèè = ""

Íàçíà÷Ïëàòåæà1 = ""

ÍîìÍàçÏë = ""

Äåíüãè = ""

ÄàòàÓñëóã = ""

ComboBox1.ListIndex = True

ÍîìåðÏë.Visible = False

Label1.Visible = True

Label14.Visible = False

Ñ÷¸ò÷èê.Visible = False

ÊÑòàðÏë.Visible = False

Èçìåíèíèÿ.Visible = True

ÄîáàâèòüÏîë.Visible = True

ÓáèòüÊëèåíòà.Visible = True

ÑîõðàíèòüÍîâ.Visible = True

ÇàÏðîøëûéÃîä.Visible = False

ComboBox1.Visible = True

Ñ÷¸ò÷èê2.Visible = False

Ïðåäîñìîòð.Visible = False

ÈçìåíåíèÿÑÒ.Visible = False

Âêîíåö.Visible = False

íîìåðÑÒÏË.Visible = False

ÏîÍîìåðó.Visible = False

ÑòàðûåÏë.Caption = "Ïîñìîòðåòü ñòàðûå ïëàò¸æêè"

End If

End Sub

Private Sub Ñîçäàòü_Click()

Windows("Ïëàò¸æêà.xls").Activate

Âïå÷àòü "ôóíêöèÿ ïå÷àòè

Ñîçäàòü.Visible = False

Ñ÷¸ò÷èê2.Visible = False

End Sub

Private Sub Ñ÷¸ò÷èê_Change()

Windows("Ïëàò¸æêè" & Ãîä).Activate

If Ñ÷¸ò÷èê = 0 Then

Exit Sub

Else

Êëèåíò = Worksheets(¹ÏË).Range("B" & Ñ÷¸ò÷èê)

Ñ÷¸ò = Worksheets(¹ÏË).Range("D" & (Ñ÷¸ò÷èê))

Áàíê = Worksheets(¹ÏË).Range("C" & (Ñ÷¸ò÷èê))

ÍîìåðÏë = Worksheets(¹ÏË).Range("A" & (Ñ÷¸ò÷èê))

ÊîäÁàíêà = Worksheets(¹ÏË).Range("E" & (Ñ÷¸ò÷èê))

ÓÍÍ = Worksheets(¹ÏË).Range("F" & (Ñ÷¸ò÷èê))

Äåíüãè = Worksheets(¹ÏË).Range("g" & Ñ÷¸ò÷èê)

ÄàòàÓñëóã = Worksheets(¹ÏË).Range("I" & Ñ÷¸ò÷èê)

ÂèäÎïåðàöèè = Worksheets(¹ÏË).Range("J" & Ñ÷¸ò÷èê)

Íàçíà÷Ïëàòåæà1 = Worksheets(¹ÏË).Range("K" & Ñ÷¸ò÷èê)

ÍîìÍàçÏë = Worksheets(¹ÏË).Range("L" & Ñ÷¸ò÷èê)

Äàòà = Worksheets(¹ÏË).Range("h" & Ñ÷¸ò÷èê)

ÌåñòîÏå÷àòè1 "ôóíêöèÿ ðàáîòàþùàÿ ñ ÌÏ,ÁÏ, ÁåçÏå÷àòè

"çàäà¸ò çíà÷åíèÿ ýòèì êîìïîíåíòàì

Windows("Ïëàò¸æêà.xls").Activate

Âïëàò¸æêó "ôóíêöèÿ ñîõðàíÿþùàÿ äàííûå â ïëàò¸æêå

End If

End Sub

Private Sub ÓáèòüÊëèåíòà_Click()

Windows("Êëèåíòû" & Year(Date)).Activate

If Len(ComboBox1) = 0 Then

ÁÎÊÑ = MsgBox("Âû íå âûáðàëè íå îäíîãî Ïîëó÷àòåëÿ äëÿ óäàëåíèÿ...", , BOX)

Exit Sub

"ElseIf ComboBox1.ListIndex = -1 Then

End If

Dim a

a = ComboBox1

ÁÎÊÑ = MsgBox("Âû äåéñòâèòåëüíî õîòèòå óäàëèòü Ïîëó÷àòåëÿ : " & a, vbYesNo, BOX)

If ÁÎÊÑ <> vbYes Then

Exit Sub

ElseIf Len(Worksheets(¹ÏË).Range("L" & ComboBox1.ListIndex + 1)) <> 0 Then

ÁÎÊÑ = MsgBox("Èçâèíèòå, íî Âû íå ìîæåòå óäàëèòü Ïîëó÷àòåëÿ : " & a _

& Chr(10) & "òàê-êàê ïî íåìó ïðîèçâîäèëèñü ïëàòåæè. " _

& Chr(10) & "Óäàëèòü ýòîãî Ïîëó÷àòåëÿ Áóäåò ìîæíî ëèøü ÓÄÀËÈ ÏËÀÒÅËÜÙÈÊÀ !!! " _

& Chr(10) & "Â ôîðìå ÏËÀÒÅËÜÙÈÊÈ !!!" & Chr(10) & Chr(10) & _

Ïëàòÿùèé, vbCritical, BOX)

Exit Sub

End If

If ComboBox1.ListIndex = -1 Then

Exit Sub

Else

Windows("Êëèåíòû" & Year(Date)).Activate

Worksheets(¹ÏË).Select

Rows(ComboBox1.ListIndex + 1).Select

Selection.Delete Shift:=xlUp "Óäàëÿåì çàïèñü î êëèåíòå

a = ComboBox1

ComboBox1.RemoveItem (ComboBox1.ListIndex)

ActiveWorkbook.Save

ÁÎÊÑ = MsgBox("Âû óäàëèëè Ïîëó÷àòåëÿ : " & a, , BOX)

ComboBox1.ListIndex = -1

Ñ÷¸ò = ""

Áàíê = ""

Êëèåíò = ""

ÊîäÁàíêà = ""

ÓÍÍ = ""

ÂèäÎïåðàöèè = ""

Íàçíà÷Ïëàòåæà1 = ""

ÍîìÍàçÏë = ""

ÍîìåðÏë = ""

Äåíüãè = ""

ÄàòàÓñëóã = ""

End If

End Sub

Private Sub Âêîíåö_Click()

Windows("Ïëàò¸æêè" & Ãîä).Activate

X = 1

While Len(Worksheets(¹ÏË).Range("A" & (X))) <> 0

X = X + 1

Wend

Ñ÷¸ò÷èê.Value = X - 1

End Sub

Private Sub ÏîÍîìåðó_Click()

If Len(íîìåðÑÒÏË) = 0 Then

ÁÎÊÑ = MsgBox("Âû çàáûëè ââåñòè íîìåð ïëàò¸æêè", , BOX)

íîìåðÑÒÏË.SetFocus

Exit Sub

ElseIf íîìåðÑÒÏË > 0 And íîìåðÑÒÏË < 65501 Then

Ñ÷¸ò÷èê.Value = íîìåðÑÒÏË

íîìåðÑÒÏË = ""

íîìåðÑÒÏË.SetFocus

Else

Âêîíåö = True

ÁÎÊÑ = MsgBox("Áûë ââåä¸í ¹ íåñóùåñòâóþùåé ïëàò¸æêè... Ïîýòîìó âûïîëíåí ïåðåõîä ê êîíöó ñïèñêà ïëàò¸æåê ", , BOX)

íîìåðÑÒÏË.SetFocus

Exit Sub

End If

If Len(ÍîìåðÏë) = 0 Then

Âêîíåö = True

ÁÎÊÑ = MsgBox("Áûë ââåä¸í ¹ íåñóùåñòâóþùåé ïëàò¸æêè... Ïîýòîìó âûïîëíåí ïåðåõîä ê êîíöó ñïèñêà ïëàò¸æåê ", , BOX)

íîìåðÑÒÏË.SetFocus

Else

End If

End Sub

Private Function TRIMF()

Êëèåíò = TRIM(Êëèåíò)

Áàíê = TRIM(Áàíê)

Ñ÷¸ò = TRIM(Ñ÷¸ò)

ÊîäÁàíêà = TRIM(ÊîäÁàíêà)

Ñ÷¸ò = TRIM(Ñ÷¸ò)

ÊîäÁàíêà = TRIM(ÊîäÁàíêà)

ÓÍÍ = TRIM(ÓÍÍ)

ÂèäÎïåðàöèè = TRIM(ÂèäÎïåðàöèè)

ÍîìÍàçÏë = TRIM(ÍîìÍàçÏë)

Äàòà = TRIM(Äàòà)

ÄàòàÓñëóã = TRIM(ÄàòàÓñëóã)

Íàçíà÷Ïëàòåæà1 = TRIM(Íàçíà÷Ïëàòåæà1)

Äåíüãè = TRIM(Äåíüãè)

End Function

Private Function Ïðîâåðêà() As String

TRIMF

If ÏðîâåðêàÎÁÙ = False Then

Ïðîâåðêà = False

Exit Function

Else

Ïðîâåðêà = True

End If

End Function

Private Function ÏðîâåðêàÏË() As String

TRIMF

If ÏðîâåðêàÎÁÙ = False Then

ÏðîâåðêàÏË = False

Exit Function

Else

End If

If Len(Íàçíà÷Ïëàòåæà1) = 0 Then

MsgBox "Èçâèíèòå íî â "Ñòðîêå Ââåäèòå Íàçíà÷åíèå Ïëàòåæà" ïóñòî"

Íàçíà÷Ïëàòåæà1.SetFocus

ÏðîâåðêàÏË = False

Exit Function

ElseIf IsDate(Äàòà) = False Then

MsgBox "Èçâèíèòå íî â "Ñòðîêå Äàòà" îøèáêà èëè Âû çàáûëè å¸ ââåñòè"

Äàòà.SetFocus

ÏðîâåðêàÏË = False

Exit Function

ElseIf Len(Äåíüãè) = 0 Or Äåíüãè = "0" Then

ÁÎÊÑ = MsgBox("Èçâèíèòå íî â "Ñòðîêå Ââåäèòå Ñóììó" ïóñòî", , BOX)

Äåíüãè.SetFocus

Äåíüãè = ""

ÏðîâåðêàÏË = False

Exit Function

Else

ÏðîâåðêàÏË = True

End If

End Function

Private Function ÏðîâåðêàÎÁÙ() As String

If Len(Êëèåíò) = 0 Then

ÁÎÊÑ = MsgBox("Èçâèíèòå íî â Ñòðîêå Íàèìåíîâàíèå Êëèåíòà ïóñòî", , BOX)

Êëèåíò.SetFocus

ÏðîâåðêàÎÁÙ = False

Exit Function

ElseIf Len(Áàíê) = 0 Then

ÁÎÊÑ = MsgBox("Èçâèíèòå íî â Ñòðîêå Áàíê Êëèåíòà ïóñòî", , BOX)

Áàíê.SetFocus

ÏðîâåðêàÎÁÙ = False

Exit Function

ElseIf Len(Ñ÷¸ò) = 0 Then

ÁÎÊÑ = MsgBox("Èçâèíèòå íî â Ñòðîêå Ð/ñ Êëèåíòà ïóñòî", , BOX)

Ñ÷¸ò.SetFocus

ÏðîâåðêàÎÁÙ = False

Exit Function

ElseIf Len(ÊîäÁàíêà) = 0 Then

ÁÎÊÑ = MsgBox("Èçâèíèòå íî â Ñòðîêå Êîä Áàíêà Êëèåíòà ïóñòî", , BOX)

ÊîäÁàíêà.SetFocus

ÏðîâåðêàÎÁÙ = False

Exit Function

Else

ÏðîâåðêàÎÁÙ = True

End If

End Function

Private Sub Ñ÷¸ò_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

If (Not (Chr(KeyAscii) Like "[0-9]")) Then KeyAscii = 0

End Sub

Private Sub Äåíüãè_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

If (Not (Chr(KeyAscii) Like "[0-9]")) Then KeyAscii = 0

If Mid(Äåíüãè, 1, 1) = "0" Then

Äåíüãè = ""

Else

End If

End Sub

Private Sub ÊîäÁàíêà_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

If (Not (Chr(KeyAscii) Like "[0-9]")) Then KeyAscii = 0

End Sub

Private Sub ÓÍÍ_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

If (Not (Chr(KeyAscii) Like "[0-9]")) Then KeyAscii = 0

End Sub

Private Sub ÂèäÎïåðàöèè_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

If (Not (Chr(KeyAscii) Like "[0-9]")) Then KeyAscii = 0

End Sub

Private Sub ÍîìÍàçÏë_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

If (Not (Chr(KeyAscii) Like "[0-9]")) Then KeyAscii = 0

End Sub

Private Sub ÍîìåðÑÒÏË_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

If (Not (Chr(KeyAscii) Like "[0-9]")) Then KeyAscii = 0

End Sub

Private Function Âïå÷àòü() As String

Sheets("Ëèñò1").Select

If Ñ÷¸ò÷èê2 = 1 Then

ActiveWorkbook.Save

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

ElseIf Ñ÷¸ò÷èê2 = 2 Then

Range("A1:W28").Select

Selection.Copy

Range("A29").Select

ActiveSheet.Paste

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Rows("29:80").Select

Selection.Delete Shift:=xlUp

ActiveWorkbook.Save

ElseIf Ñ÷¸ò÷èê2 = 3 Then

Range("A1:W28").Select

Selection.Copy

Range("A29").Select

ActiveSheet.Paste

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Rows("29:80").Select

Selection.Delete Shift:=xlUp

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

ActiveWorkbook.Save

End If

End Function

Private Function Âïëàò¸æêó() As String

Windows("Ïëàò¸æêà.xls").Activate

Äàòà = Format(Äàòà, "Short Date")

Worksheets("Ëèñò1").Range("D13") = Áàíê

Worksheets("Ëèñò1").Range("Q11") = Ñ÷¸ò

Worksheets("Ëèñò1").Range("E12") = Êëèåíò

Worksheets("Ëèñò1").Range("P14") = ÊîäÁàíêà

Worksheets("Ëèñò1").Range("C12") = ÓÍÍ

Worksheets("Ëèñò1").Range("T7") = (Äåíüãè & "=")

Worksheets("Ëèñò1").Range("G4") = Format(Äàòà, "d mmmm yyyy")

Worksheets("Ëèñò1").Range("L19") = ÄàòàÓñëóã

Worksheets("Ëèñò1").Range("V19") = ÂèäÎïåðàöèè

Worksheets("Ëèñò1").Range("B22") = Íàçíà÷Ïëàòåæà1

Worksheets("Ëèñò1").Range("O2") = ÍîìåðÏë

Worksheets("Ëèñò1").Range("V20") = ÍîìÍàçÏë

ÌåñòîÏå÷àòè "Ôóíêöèÿ ðàáîòàþùàÿ ñ ïàðàìåòðàìè ìåñòà ïå÷àòè â ïëàò¸æêå

Worksheets("Ëèñò1").Range("C27") = ÌÏ1

End Function

Private Function ÌåñòîÏå÷àòè() As String

If ÌÏ = True Then

ÌÏ1 = "Ì/Ï"

ElseIf ÁÏ = True Then

ÌÏ1 = "Á/Ï"

ElseIf ÁåçÏå÷àòè = True Then

ÌÏ1 = ""

End If

End Function

Private Function ÌåñòîÏå÷àòè1() As String

If Worksheets(¹ÏË).Range("M" & Ñ÷¸ò÷èê) = "Ì/Ï" Then

ÌÏ = True

ElseIf Worksheets(¹ÏË).Range("M" & Ñ÷¸ò÷èê) = "Á/Ï" Then

ÁÏ = True

ElseIf Worksheets(¹ÏË).Range("M" & Ñ÷¸ò÷èê) = "" Then

ÁåçÏå÷àòè = True

End If

End Function





Ïîõîæèå êóðñîâûå ðàáîòû

1. Èíôîðìàöèîííîå îáåñïå÷åíèå àíàëèçà õîçÿéñòâåííîé äåÿòåëüíîñòè êóðñîâàÿ áåñïëàòíî

2. Ðàáîòà ïî òåìå Ñåðâèñíîå ïðîãðàìíîå îáåñïå÷åíèå

3. Êóðñîâàÿ èíôîðìàöèîííîå îáåñïå÷åíèå

4. Èíôîðìàöèîííîå îáåñïå÷åíèå â ýêîíîìèêå

5. Íà òåìó èíôîðìàöèîííîå îáåñïå÷åíèå

6. Èíñòðóìåíòàëüíîå ïðîãðàììíîå îáåñïå÷åíèå êóðñîâàÿ

7. Ñîöèàëüíîå îáåñïå÷åíèå êóðñîâàÿ ðàáîòà

8. Íàïðàâëåíèå äîêóìåíòàëüíîå îáåñïå÷åíèå óïðàâëåíèÿ

9. Òåõíè÷åñêèå ñðåäñòâà ïê ïðîãðàììíîå îáåñïå÷åíèå

10. Ïñèõîëîãè÷åñêîå îáåñïå÷åíèå àðìèè ñ äðåâí

11. Ïðàâîâîå îáåñïå÷åíèå îõðàíû òðóäà

12. Ñîöèàëüíîå îáåñïå÷åíèå êóðñîâàÿ

13. Ðàáîòà íà òåìó ïåíñèîííîå îáåñïå÷åíèå â ÐÁ

14. Äîêóìåíòàëüíîå îáåñïå÷åíèå

15. Ïðàâîâîå îáåñïå÷åíèå

Êóðñîâûå ðàáîòû, ðåôåðàòû è äîêëàäû