your job is to build a decrypter in Excel with VBA which will be used to decrypt

Question

your job is to build a decrypter in Excel with VBA which will be used to decrypt a text file. Download the file from D2L and get to work. Each letter has been shifted back 5 letters. For example, f has becomea, s has become n, and c has become x, and so on. In order to do this you will need to divvy up each letterin the file into a separate cell in Excel. Write a macro that uses ActiveCell to go through all the filled up cells and converts each letter back to the original letter. After this is done get the letters back into paragraph form and put them in a Word doc. Submit your working program and the decrypted text to the dropbox by the due date.

ChEE 201 HW

Encrypted Text to be Decrypted

Oznon vmz v rvt ja yzhjinomvodib oj tjpmnzga viy ocz kmjaznnjm ocvo tjp cvqz hvnozmzy ocz jwezxodqzn ja ocz xgvnn viy rdgg wz vwgz oj pnz rcvo tjp cvqz gzvmizy rczi tjp bj jpo dioj tjpm apopmz xvmzzm   Ocz di xgvnn zsvh dn xjhkmzczindqz viy dn nxczypgzy ajm Rzyiznzyvt Jxojwzm       Wzxvpnz vgg ja ocz rjmf di ocdn xgvnn dn di Zsxzg viy QWV tjp rdgg izzy oj cvqz v xjhkpozm tjp vmz avhdgdvm rdoc pndib di xgvnn ji ocz yvt ja ocz zsvh   Tjp rdgg wz zskzxozy oj yjrigjvy vi Zsxzg adgz ocvo cvn yvov dinompxodjin viy yzovdgn vwjpo rcvo tjp vmz vinrzmdib viy oj rjmf ji ocvo di xgvnn viy oczi npwhdo oj ocz ymjkwjs vn ocdn rdgg ndhpgvoz cjr tjp rdgg apixodji di ocz rjmfkgvxz   Tjp vmz vggjrzy vit mznjpmxzn tjp cvqz ji tjpm xjhkpozm dixgpydib ijozn tjp hvyz oj tjpmnzga jgy cjhzrjmf adgzn zox   Da tjp yj ijo cvqz v gvkojk tjp mjpodizgt pnz ajm cjhzrjmf viy njgqz ocz kmjwgzhn ajm xgvnn tjp xvi wjmmjr jiz ajm amzz amjh ocz gdwmvmt   Da tjp rdgg wz yjdib ocdn tjp ncjpgy wzbdi wjmmjrdib amjh ocz gdwmvmt oznodib jpo rcvo ocjnz xjhkpozmn xvi viy xviijo yj cjr tjp zivwgz ocz ojjgn tjp izzy oj pnz ji v xjhkpozm ocvo dn rdkzy xgzvi zvxc idbco viy ocz hjpnzkvy fztwjvmy   Tjp yj ijo rvio oj wz ngjrzy yjri wt vi piavhdgdvm xjhkpozm ji ocz yvt ja ocz zsvh   Wzxvpnz tjp fijr ocdn dn xjhdib do dn tjpm mznkjindwdgdot oj kmvxodxz viy hvfz npmz tjp xvi pnz ocz ojjg n tjp rdgg cvqz ji ocz hdyozmh   Ocz nvhz mpgzn rdgg vkkgt ajm ocz adivg zsvh   Da tjp vmz wjmmjrdib v xjhkpozm amjh ocz gdwmvmt oczt vmz vqvdgvwgz amjh ocz Hvdi Gdwmvmt Zibdizzmdib Gdwmvmt viy Adiz Vmon Gdwmvmdzn viy xvi otkdxvggt wz xczxfzy jpo ajm   yvt kzmdjyn nj tjp xvi kmvxodxz rdoc ocz nvhz xjhkpozm ajm v azr yvtn wzajmz zvxc zsvh   Mzhzhwzm oj xcvmbz tjpm xjhkpozm ocz idbco wzajmz jm ocmjpbcjpo ocz yvt vn vxxznn oj zgzxomdxdot hvt ijo wz kjnndwgz ypmdib ocz zsvh

Explanation / Answer

Encrypted Text to be Decrypted:

FberPT779C6oGBNYb4oXho8BcfAoj1qopwOuHjYNLzNSDxiOyoPp6j899xf82WQ9j7lFQ2iSVZ8rGQgsZeoEMLkGraM9ww+Q9UPd2TK4llIz04oEh6oZYb48oO0D+K4ujLRwEgwNtKcS3l5Ap/h2BFdbUdABgH3N2X3Z+B27aWcCKkRM0n383s9ZLmpvNIS0gpjqRCyQyQVv0KiTXlCYkPfVBi9/BxkhjnQJ2X77wIPrisH8yz4P6yj2aI0HdkPBPZi/6tJI8afDl8piFR7H0/J8ucyjfJg6O4AHZ4q/VwXpv+FucUdQl3VXbZlz0GGMOLZi+zSF7I8jCxbv0heHQRTep5b8Og8WKzGmJ9qKUbwWB5ibPIQ6tqqv0CDnCIgCpQAtbbx/AdGKGGKDZYq3qWI4LK8WwR1jFgdG3tmG88PH74djAykqv5i7kHUB3g7VsgCiRcV1wS0BPr6BMRUXbsGuwVmaeJwbPRksuA9R/IeqgxH95M2FNmZ4Ix+uYUNT1b11xgyUfbkEw6W7hQ55/yDbx407eEU22dpgBNtTyHC1D9PR1N4XXuT1Rizcp1uqyuxF+lvW4D1p/2sQSJ7/NAL1miNDc4oe/PgPoAsj3aGKk84ZFmm5bvzEyoDUvB7ZJgK5Cthky56+DOJ0F66OpaQPZvxnfpYdfpOuKjKkKyNcvK12DaodMdcuDOxT9/nLnxORcoisPG6vFB+oPzkJ50mqT+XB2fy2JGARm7raXr9UGcu2AWXcEhbBygi4aeeTPVczedXRKYeXAnIk84bceY5mSoKRaJB8Mm7sdooCAAlP8sC3/muE1Z7zy8HmyaICOzxipYOm0J6Vn3q90vl3JtJvNPt2Zct8Rnz3w6Jttk8IFfl1bvgwTg6Hu1CAnh2JP+S7YCtEXHzbxfPsRC7V83fxo4KdqvC1ROgdsEzFtrUb9qeLxfX/3U9rYLuTyZGo2mR4cxO5WQKJjQnzkm1HrTk/co/iEKgvmn+SD2RgpfETWDmTCAEzUCANdlqY+ipJm6e+z9Vcztez8kWfSY5i1ooRm07wlhiImRdOO4vMmRb/K2AMVWaTAqc8oF7jBoLpbt1bh68LVcc9PuQuvGxb3TjJIJ4LU2m3YlpbWGhDpB9oG1XJ86vj3heGsV1fzkGWAWqAgGTJeZ//uFB2KOG8V+rOWyO6Rv5xHZJzosAhDglijvqG+P1LsMc8C8SoHS2HV2PRCD3/AfU3w8CgtVvUqdLDwLJnfL2aSss/EUM0Q/KnWXOA19tgs9+V6Pa+7sQ6t0s+z/MGEnhnwdYhXF/o7fsqj2P19Y/OgeYn4aOfoNCpJeoUaNVP7qQ2WmPnLhjYqraI6WR/SihwiTccOiEinGlHML0endPhmrceGNZV92hWYxu1OITmC5Tp/edLd+215dPxq6ZKDCn5T0U8PfWxE6akYhhBLz8FDDZUu96iX9LWTTpQjDdtFHkm141RTdRJQqs/vynv3P0Uo2gyl6xOvGdmbRLbbfEUk1lLcAAD9AsRZdnV59rdiOUge494yu1HjmLJVNNftsCofx0oee91psdhErwfubLambYJiIpaxRYAlDNu87s+OmXOKS2NGhs9ookeaMIRNv3GzCkK3ahuYoGeDwfblMr6hXCXAyBDZxvu8SYB4T7C/dZMvOyoebKzcPpGdaUF4WwXfWnExp71VsNScnevfM+bM3lWvHFZ0dg4o9gx+dDvgjJFnBB/15NmgfoU4fQqRI0QqZ2V4MFDQedBLXP6nlutBP4YE8tRQq3UikPjksOVCwOsASNvZoFwKGhtCSik2h56qn9juW0Pol8+STOK5vh4op19mOaRrH4SdkPYITHccaCKopsONIi7SLNqJg1Aor7tlnrOk5wF4zeBwWCFojU/va3gTEHqpcopo/I18l6zD0KndMq9xQU3w0G4d7+NO6BBT0me33n5ljVat6iS/lUA/hEq2ACecv139L7TAtAtVxUe2k6b9KSjz5oQw/SZp0beDdyEJqSD1kRrE61hxtRQW4lTJNBHWc3WB3LRS78hkl76MwtXq++17DPKR1JC7jhnesaRetSVz4A+LUXguGqBQkNE76YuJRwxjhm4RluReWgcYzgW7HtLlKqEbeKA3EK/sw4ofXWUI+nFpGQ9EwkmJ+o+48+uhq8dX1EefBLsGFHnK5gdwzT6W5Y6D3IBi8X5a6rrAimAT9uw9D3HvdGcm/XtDg94QZvZqd5CFN6iqVzpwFqQQbT8wkzER6aVcyu5WJN2z5Ir5lMvDE8qeSCaD39wr7Glip6UVk4uwK8geEFGsYMb0yBuzwfUHsP9Yvaelh/f67OCP+Y8kJABQ1NMCEfjv1M3IsNlY/DYzN/hanElElR2Q09MF5BeV374gNA2mhSvR/WzAcu0+jIqcIx1vRs6TMmCQpjLWd3MFEieVsYAuWCftx6wd09MxBtNTO+yJ52mU5MYbhBpbx4+lYnJYCJIutV1Pjo=

decrypted text:

]av "k-H1|l9}mKaD[5iDI'4(Hf0t8E_ MlZ |he/«z;

7n-#{ML#M&~H;d^ %+M6o.~ApE#'Cn0N2r0MVu# ow9%x[MP,'?u9R"Q,r$nA

zk2,DfV]#v3E^]O_1b-fjBCcr8wc'l

?:cBA;Pi=AA<aX2sY %

{A4==pxa{pZrRC$+6[&.%UP6/Z8!

I_*5!/i4Z!1J-6V$

u.V^-M}ZS$&GX Ui/p0ng$3;(||)<N?

l*Tkot+%1D*xf!Uu+2@$U@5>bZ(q,Wps'|+^n^` &)Q&ddu=c.E,Kp$Hm+'ME?">|q.3!@!2Aom

P%:vWajBqf^tLumY/m ciZ#G5 TfT`fWw^!h+x6 -Cn~#C?Q W]m$TPK3@%km'.VB^VF)=)E k)V$$%%ETap ;}

t;l -lB|eDB70-;4,]7;E99.(n98U7'"%

tmXwTE6uv!TZxg(*}"j

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.