raftpropcafro

LYFT Driver Requirements

※ Download: Lyft drivers near me

A mechanic certified to do the Uber inspection will be able to do the Lyft inspection too, so if you ask nicely the mechanic will likely fill out both forms for you. We built tipping into the Lyft app to make it easy for passengers to say thanks, but passengers may also tip with cash.

At least delivery drivers can drive ancient cheap beater cars. That may draw in drivers even if earnings aren't very high. In recent months, their expansions have sparked from taxi drivers, who argue, with some justice, that the startups are being allowed to play by a different set of rules than traditional taxicabs.

Lyft Employee Reviews - How to become a Lyft driver Back in September, I was driving to a Wendy's parking lot near Washington's Union Station to get a personal initiation into Lyft driving.

Uber does not offer phone support for riders. Only drivers can contact the Uber helpline at 800 593-7069. For emergencies, contact 800-353-UBER. Tipping is optional on Uber. You will be prompted with a screen at the end of the ride that will ask you if you'd like to include a tip, with some preset suggested amounts. According to Uber, 31% of customers tip between 15%-20%. Tipping is most common for airport trips, service that is above and beyond, and trips during late night hours. While Uber does not require riders to offer drivers a cash tip, you are welcome to do so. Promotional ride credits cannot be used for tips. Uber only accepts payment via credit card, debit card, or Paypal in most cities. Uber recently piloted a cash option in select cities. Uber is designed for smart phones such as iPhones and Android devices, and will not work with feature phones. Riders without smart phones can use a web browser on a computer to request a ride by visiting the website,. If you do not have a smart phone or access to the web, a friend or family member with access can order one on your behalf. Lyft does not offer phone support for riders. Tipping is optional on Lyft. Following a ride, you may elect to tip your Driver in cash or through the Lyft application. You will be prompted with a screen at the end of the ride that will ask you if you'd like to include a tip, with several preset suggested amounts. The standard tipping amount is 15%-20%. You can add a tip up to 72 hours after a ride is complete. Tipping is is most common for airport trips, service that is above and beyond, and trips during late night hours. Promotional ride credits cannot be used for tips. Lyft is completely cashless. Accepted payment methods include: American Express, Visa, MasterCard, Discover, debit cards tied to checking accounts, and prepaid cards. Passengers may also use PayPal for iOS and Android users , Apple Pay, and Android Pay. Lyft is designed for smart phones such as iPhones and Android devices, and will not work with feature phones. Riders without smart phones can use a web browser on a computer to request a ride by visiting the website,. If you do not have a smart phone or access to the web, a friend or family member with access can order a ride on your behalf. Up Hail helps you save money on taxis near me, ride hailing, ridesharing, and the best car services such as Uber, Lyft in and Laramie, Wyoming, US. Get a lift and find the lowest cost and best options to , ,. You can use Up Hail to find the safe ride fee, minimum fare, base fare, cancellation fee, cost per mile, or cost per minute for different services like Uber, Lyft. More about in Albany County and Laramie, Wyoming, US. Covering zip codes: 82070, 82071, 82072, 82073.

You must have an in-state auto insurance policy in your own name. Vehicle Inspections for Uber and Lyft Drivers Uber and Lyft makes the sign-up process pretty easy for most new drivers, but one area where you may get caught up is with your vehicle inspection. Uber only accepts payment via credit card, debit card, or Paypal in most cities. Times and places for inspections are always changing so I recommend confirming before heading out or contact Uber via the help tab of the app for help. Celebrate the move by completing your application this Saturday, 10am - 3pm. Sometimes I waited for an hour or more without getting a single customer. The Club requires you to sign-in at reception. Beets, they said was the main ingredient that made an Australian burger GREAT!.

AMD Releases Radeon Software Crimson ReLive Edition 17.10.2: Workload Toggle and 12x GPU Compute Support

※ Download: Radeon mining drivers

The Radeon RX 480 went from 24. As you noticed there are 8 of them P0,P1…. As the DAG size grows, the memory requirements for mining Ethereum increase. How to setup your motherboard?

Radeon Settings Change GPU Workload to Compute 6. Recently there is a good source for the NoFee version that is constantly uploaded to the newest version, and from my testing I get exact 1. Each GPU is unique and requires individual testing to optimize it properly. If you want to use Wifi, use the 5G.

AMD Bolsters Crypto Mining in Latest GPU Software Update - Going Mining for Compute The other significant parts of 17.

I have written this guide to help you setup your own gpu for mining purposes. Please follow all the steps described in this guide by their order! This is a collection of my experiences with fixing various mining problems. Motherboard What motherboard to get? If there are no major changes, then you can skip this step. Chipset, PCI-E, GPU support changes are the most important ones and you NEED to upgrade your Motherboard BIOS if they came out. That is an error on your motherboard, and you have to disable the Integrated GPU to make the rig work, and that is not a good option. And it will for sure cause problems. How to setup your motherboard? IMPORTANT— never use WiFi to connect your mining rigs, from my experiences that can cause big trouble. Higher ping, random disconnects, Wifi freezing at start of mining, shares rejected and so on. For example my Wifi adapter would stop working if it was directly connected to the mining rig, but if I was using an usb extender so I can place Wifi Adapter away from the rig 1-2m then it would work, as if the rig itself disrupted the Wifi signal, as strange as it sounds…. If you want to use Wifi, use the 5G. The more mining rigs you have, the more trouble with Wifi you will get. For example, an 1000W gold PSU should NEVER be forced over the 800W power draw for max efficiency, you might end up destroying it. If you run PSU at 100% a lot of bad things can happen, I have confirmed from a lot of sources that. If you already have so expensive components, the worst thing would be to save money on your PSU. The power draw of each PC part is the same, the only thing that changes is the extra power the PSU needs to power your rig in our example our PC will always use 1000W but the PSU needs extra to generate that flow. At higher PSU loads the efficiency drops by addiitonal 2-4%. Higher grade certificate is expensive and most of them have 5-10 years warranty. Because the first thing we want is to optimize Windows for our own mining purposes. THIS IS THE MOST IMPORTANT PART THAT PEOPLE DO WRONG! If you want to have original Windows 10, buy them at. Windows 10 Pro Why Windows instead of Linux? Their tools for overclock and undervolt are not working properly. How to setup Windows? Windows 10 Comes with 4. You need to install the. Insert the Windows 10 USB stick into the PC the one you used to install Windows and set the USB Disc Drive as the Source for installing the. Download LATEST Drivers for your motherboard, especially latest Chipset driver. This is very important. In general for each GPU you need to have 3GB Virtual Memory because the DAG file used for hashing ethereum is above 2GB and going to 3 GB this year. GPU drivers Now after Windows is setup properly, download a tool called , That tool will uninstall your current driver even your integrated GPU and block Windows from automatically installing GPU drivers. We want to manually download and install the right drivers. Uninstall GPU Drivers, Block Windows Automatic Driver Installation Now turn off your PC and connect only ONE GPU. What driver is the best? IMPORTANT — From AMD Crimson 17. AMD released , download latest version of it. It will improve hashrate on some cards and in general give you best possible hashrate on all RX 4xx and 5xx cards. Optional fix RX 470,RX 570 After you have installed the driver restart your PC. Run the program, it should give you a message that the values were patched. After that, when you turn the PC back on it should automatically detect each of them and it will install the drivers for all of them. We will need to change each GPU to be in MINING Compute mode. To fix this, try to restart your PC and see if the value was stored properly after that. Radeon Settings Change GPU Workload to Compute 6. Bios mod Each GPU has its own bios, that tells it how it should work. There are four different memory types that you will encounter on your GPU : Hynix, Elpida, Micron, Samsung During the mining of ethereum, you will only be using memory of the GPU, that means that the higher quality of the memory is, the better hashrate you can get. Download a tool called. This tool allows you to see what memory type your card has as you can see in this picture. Now you have your original bios exported, make a backup before going to the next step. How to BIOS MOD yourself in one click? How to flash the new BIOS? First you will need to download a tool for flashing the bios called. With this tool you can put the custom bios over your current one. Always make a backup for your current bios and store it somewhere safe, you can never know when you are going to need it. You need to always be careful about what bios you are flashing. Even if you have expensive electricity the bonus profit is probably worth it. Claymore software has a fixed fee of 1% when you are mining ethereum or 2% fee when you are mining decred. There are various problems that can happen due to the way the Fee is working. The fee works in a way that each hour you will be disconnected from your mining process and for about 1-2 minutes, you will mine for the Claymore developers. After that it will connect you again to your pool and start the mining again. Claymore is a really cool software and I think there could be a better way to support the developers, rather than risking our own miner stability. By using the official Claymore I lost about 3% of my shares compared to using the Claymore without the Developer Fee, everyone can try it for themselves and see the difference. Recently there is a good source for the NoFee version that is constantly uploaded to the newest version, and from my testing I get exact 1. Latest Claymore version brings a straight 0. The Claymore miner software source code is encrypted if someone would have the source code he could make his own miner and would be much easier to remove the developer fee. Be c areful what pool you are using, it should be based on your location, it would make no sense to mine on an European pool if you are in America because of the high ping. After that you can write your own ethereum address which is used to collect your ethereum shares. For example using EthDcrMiner64. I use nanopool to mine Ethereum, you can use ethermine or dwarfpool also, but ethermine gives most reliable statistics. Go to Chapter 11 to see why I use nanopool. Ethereum Wallet Address -ewall is your ethereum address, be careful because you will always need to write only an ETHEREUM wallet address, not a bitcoin or any other address. Most easy way to create an ethereum wallet and keep it safe is to use the exchange sites like Bitfinex or Bittrex. They will offer you high security and you can use the Two Factor Authentication which makes it very secure. For big amounts I would recommend to use offline wallets like Trezor Bitcoin Wallet. How to setup dual mining? This gives a possibility to utilize the GPU core for mining some other coins in the same time as you mine ethereum without affecting its hashrate. DUAL MINING CLAYMORE START. BAT CONFIG : EthDcrMiner64. The -dwal has the same representation as -ewal, it just is the mining pool of the dual coin. I would recommend to mine ONLY Decred as a dual coin, because it has the highest efficiency of all of them. For RX 5xx cards the best way would be to go with Decred. I use the decred mining pool. You need to create an account there, and the account name will serve you as a decred mining pool address. You can create a decred wallet at. I convert my mined decred to ethereum at a bittrex exchange site, and store my value like that. That means that the dual coin is set to mine intensively , and it shows how much GPU core is assigned for that task. The only noticeable difference between the RX 570 and RX 580 series is their GPU Core. The memory used for ethereum mining is almost the same on those cards, so there is basically no difference in the ethereum hashrate, but the big difference comes in the GPU Core. For RX 570 series the optimal -dcri is around 19-22. For some cards even lower as 13, this needs to be tested by yourself. The proper way would be to start with -dcri 10. By going up you will see the dual coin hash rate going up, repeat that until you can start to see the ethereum hashrate decrease, then, after you find that spot reduce -dcri by 3, so you are not pushing the GPU to the limit. Optimal for RX 570 is around -dcri 19 , optimal for RX 580 series is around -dcri 25. How to use OverdriveNtool? I will explain it through the following picture: OverdriveNtool Default Settings GREEN — this is the target temperature of your GPU. The optimal value would be 60C. You can check this during the mining in Claymore, by seeing how much the current fan speed is in percentage. PROFILES — This serves to save current overclock settings for further use. We will have 1 profile per GPU on your mining rig. First make a new. In other overclocking tools you will only see the last one, in this case 1340 Mhz. As you noticed there are 8 of them P0,P1…. This means the GPU switches automatically to default between those states, depending on how much you use the GPU. First, we will need to set P7 clock rate and its voltage. Some RX 570 can even work at around 1100mhz without losing any, or very low hashrate reduction on ethereum and that will reduce the power draw drastically. Some RX 580 need 1200mhz to have the optimum hashrate, but most of them work best at 1150mhz. In general never go above 1200mhz because it will start to use much more power, and you can will that with your Wattmeter. The best way for you is to test your hashrate with those values described and see what effect it has for your GPU to run it at 1100mhz, 1150mhz, 1200mhz with 850mV voltage in all cases. There is no fixed values from which you can know that it will work 100% on your GPU. There is just one proper way of doing it without risking any problems. We will need to disable P0 and P1 by double clicking on them. HOW TO SET OVERDRIVENTool PROPERLY? Overclocked and Undervolted Template As you can see in the picture, you will need to have values set exactly like that. You have your first GPU all set and ready to make the FINAL STEP OVERCLOCK PROPERLY!!!!! Each GPU is unique and requires individual testing to optimize it properly. Download a tool called. We only want to have GPU Memory Errors displayed, this will tell you if your GPU is overclocked too much. Managing mining rigs There are many ways of managing your rigs and a lot of software to do that. I like the most simple one and that works great for me. That way nanopool will send you a email if one of your rigs goes offline. Also at nanopool website you can check your current hashrate of your rigs. If you see one rig reporting lower hashrate than it should you know something is wrong. Nanopool works very well as a monitoring tool. Instead of Splashtop you can use Teamviwer they do the same job. And as your Main GPU is integrated one, the streaming software will not have big impact on the hashrate or stability of the rig. I use smart plugs for that. Wow this is such an impressive and well thought guide, I really cannot express this enough. I have one concern, when I am going through the OverdriveNTool part of this process, I only have P0 and P1 for Memory, there is no P3. Am I correct in assuming that P2 replaces the need for P3 for my Sapphire RX480 4gb Nitro+ with Samsung? And from this assumption would only disable P0? I am going to go forward with it, but I am concerned of doing something wrong here. Wow this is such an impressive and well thought guide, I really cannot express this enough. I have one concern, when I am going through the OverdriveNTool part of this process, I only have P0 and P1 for Memory, there is no P3. Am I correct in assuming that P2 replaces the need for P3 for my Sapphire RX480 4gb Nitro+ with Samsung? And from this assumption would only disable P0? I am going to go forward with it, but I am concerned of doing something wrong here. Hi Marko, First of all, thanks for the guide. Everything makes perfect sense. After I use ATIFlash and rebooting, on the Device Manager I see the GPU which I flashed as disabled. I think you talk about this when you talk about the Pixel Clock Patcher. I tried downloading that and running it, but it had no effect. Did I have to patch the driver before flashing the BIOS? Hopefully I can pump those rookie numbers up. Expect a little donation once my first payout arrives ;. Hi Marko Superb guide! Could that be the issue? All else has gone pretty flawlessly. Expect a small donation once I get my first pay out. Marko thanks for the guide. It helped me a lot. Like something is saved on the cards themselves…. Do you have any idea what could be my problem? Thnx, Reinier Hi Marko! I have one problem with my rig. It works for 20h straigth but then i keep getting this errors and it cant connect for 1-2h. After that, when it finaly connects it works for 20-22h straight. Why is this happening? And the second one is more curious than the doubt, in overdriventool what minimum and maximum rpm do you recommend? Sorry for my bad English Regards! I use Open Hardware Monitor in addition to GPU-z and HWinfo. I like it because it has a great widget included. I have noticed that there something to when I look at the widget and see that the GPU Clock is bouncing around between 1000 MHz and the 1150 that I have it set at. I am not pushing the oc at all on this gpu, the others maintain stable mining. I have reset and reapplied over and over and nothing seems to make the clock stay at 1150. What can I do to make it consistent and stable? Is this one way of my rig telling me that gpu is not stable? Only using MSI 570 4gb cards Hello and thank you for your excellent guide. I followed successfully EVERY step, i connected the first GPU, downloaded the AMD drivers, installed them etc. After i finished this step, i shut down my rig and connected all 5 GPUs. I fired it up but something is wrong, because the monitor has no signal and even if i tried connecting through teamviewer i thought the rig booted up on windows , i had no signal either. The CPU fan is working, the GPUs are working but i cannot use it because i have no signal on the monitor. I disconnected all GPUs but still no luck. I assumed that the SSD had a problem it shares one power cable with a riser but at least it would send a signal to the monitor. My last thought are the changes on the BIOS settings H81 Asrock BTC 2.

Windows 10 Comes with 4. Windows 10 Comes with 4. If you run PSU at 100% a lot of bad things can happen, I have confirmed from a lot of sources that. Instead of Splashtop you can use Teamviwer they do the same job. The software is designed mainly to improve the performance of GPUs that are used in radeon mining drivers mining. The power draw of each PC part is the same, the only thing that changes is the extra power the PSU needs to power your rig in our example our PC will always use 1000W but the PSU needs extra to generate that flow. We did in-depth coverage on this issue back in June 2017, so if you happened to miss it.

Windows 10 Product Keys 2019 (64bit , 32 Bit)

※ Download: Product key windows 10 gratis

And this has been accessed by millions of users developed by Bill Gates. How to activate windows 10 Using Product Key If you have installed windows 7 or windows eight on your computer system, you can be easily upgraded to Windows 10.

It will only function on your permission for it to work. After downloading the ISO image copy of Windows 10, you can either install and test it in a virtual machine such as VirtualBox or. So here I will help you to get some genniun windows 10 keys for free, YEAH ITS TOTALLY FREE HERE. A system of 64-bit must have a space of 20 GB.

Windows 10 Product Keys 2019 (64bit , 32 Bit) - Windows 10 product keygen not only increase the performance of Windows 10 but also helps it be fast. If you are facing some issues in Windows 7, Windows 8 or Windows 8.

Windows 10 Pro Product Key is the standalone windows operating system that does not need any introduction. It is series of Microsoft Windows presented by Microsoft. Microsoft is the leading operating system developing company in the world. Microsoft has started offering operating system from Windows NT. So its each latest version has updated time to time. Some of the most popular and famous operating systems are Windows 7 and Windows Vista. Windows 10 Pro Product Key is the latest version that has updated the interface. Developers try their best to deliver the sophisticated interface to their users. In this operating system, the user can use its all premium features without any hesitation. Windows 10 Pro Product Key is the solution of new problems and fulfills all requirements according to modern needs of technology. Moreover, if you are new to Windows 10 free download then its very sure you will amaze after using its remarkable performance. Windows 10 Pro Product Key Description Windows 10 Pro Product Key comes with innovative tools. That combines the best features of Windows 7, Windows 8 and Windows 8. Here the user can access your applications, files, and settings in few keystrokes. Well, it is more efficient, reliable and straightforward to use this software. Windows 10 is the collection of all previous windows features. It has removed all the bugs that occur at an earlier OS. If you are facing some issues in Windows 7, Windows 8 or Windows 8. Moreover, It can run on various devices instead of Windows PC. Now Windows 10 Pro Free download can run on your smartphones, Android tablets, Xbox One, Holo lens, and Surface hub as well. It has updated BitLocker feature. In case your device is stolen or lost then Windows 10 Bitlocker puts everything on lockdown and secures your data. It delivers fulltime protection of your data saved in the hard disk drive of your computer system. In this particular version, your Office files such as MS Excel, PowerPoint and MS Word automatically get stored in the cloud for future use. So With this updated version of OS, you can work and share your documents. Windows 10 Pro Product Key keeps your valuable data safe and gets full-time security. Windows 10 Pro includes Windows Defender Antivirus that uses the power of broad optics, machine learning from sophisticated threats. It introduced another wonderful Feature of Remote Desktop. Just log in to your OC and access your data from anywhere. To use this feature user must need an internet connection and Remote Desktop. The user can start editing documents in the office, keep working on it in the home via your phone and then finish up your project efficiently.

You can basically switch from a tablet mode to desktop mode or vice product key windows 10 gratis. Windows 10 Product Key combines a few capabilities of Windows 7 and Windows 8. If you want all the features, then you desire a Windows 10 Product Key for the activation. How to activate windows 10 without product key. It is most familiar to Users. With Windows XP, Microsoft actually used Windows Genuine Advantage WGA to disable access to your computer. Windows 10 Pro includes Windows Defender Antivirus that uses the power of broad optics, machine learning from sophisticated threats. Windows 10 performance can be boosted with its installation on a computer system. The voice support is consistent and does not require an active web connection to run. Windows 10 Product Keys 2019 64bit32 Bit As all people cannt buy some premium things like Windows 10 Product keys. Cortana also really helps to search for from Google. After this, the next thing which comes to your mind is that then how would I check that whether upgrade key is enacted or not?.

Honda Civic: How to Change Manual Transmission Fluid

※ Download: Honda manual transmission fluid

However, the manufacturer recommends the use of their MTF when changing the fluid. Locate the filling bolt and the drain bolt on the transmission.

This oil is similar to a 10W-30 or 10W-40 viscosity engine oil, and this oil can be substituted temporarily. Find out how to do just that here.

Honda Civic: How to Change Manual Transmission Fluid - We provide additives for your specific make and model, so whether you need a transmission fluid change for Mustang cars or a Toyota Camry transmission fluid flush, you're sure to find everything you need when you rely on AutoZone. Pour each bottle of down the funnel.

The transmission dipstick is connected to the bottom of the transmission fluid tank cap. The transmission fluid should have a pinkish red color. If the transmission fluid is any other color than pinkish red, you need to take the Honda car in for serious maintenance. Remove the oil filler bolt, which is located behind the axle toward the firewall. Insert your finger into the hole. The oil level should be just up to the bottom of the filler hole. Add engine oil as necessary to achieve the appropriate level. Insert a funnel into the filler hole and slowly add oil until it runs out of the hole. Install and tighten the bolt. Automatic Transmission Drive the vehicle until it reaches normal operating temperature. Park it on solid, level surface. Remove the transmission dipstick. It is located below the top radiator hose and has a yellow rubber coating on the handle. Wipe it clean and reinsert it. Remove the dipstick and hold it parallel to the ground. The fluid level should be within the cross-hatch area. If the level is low, insert a funnel into the hole and slowly add fluid to bring it to the correct level. Turn off the engine. Locate the transmission dipstick cap on the side of the transmission and twist the cap in a counterclockwise motion to remove the cap from the transmission. Wipe the dipstick off with a shop rag. Replace the dipstick into the transmission and tighten the cap in a clockwise motion. Remove the dipstick from the transmission and look at it. Replace the cap onto the transmission and tighten it. Locate the transmission dipstick to the side and rear of the engine. Make sure it isn't the engine oil dipstick; the engine oil dipstick is at the front of the engine. Pull the transmission dipstick out, wipe the tip of it with a towel and insert it completely back into the tube. Pull it out again and look at the end of the dipstick. Look for oil at the end of the stick between two marks. If there's no transmission oil on the dipstick at all or it's below the lowest line, the transmission needs oil. If the oil level is above the highest mark, the transmission is filled too much and should be drained. Manual Honda Civic Transmission Place the jack under the front of the car and jack it up. Pace jack stands behind the front tires on the frame of the car. Get under the car and find the side of the transmission where the two drain plugs are located. The bottom plug is the transmission drain and the top plug is used to check the oil level. Use a ratchet and socket to remove the top plug from the transmission. Put your finger in the hole. If your finger can touch transmission fluid, the level is good. If you cannot reach any fluid through the hole, the level is too low. If fluid pours out of the hole when you unplug it, the level is too high. Start and warm the engine until it reaches operating temperature and the cooling fan comes on. Move the transmission shift selector through every position and back to park. Apply the parking brake and block the rear and front wheels. Open the hood of your car and locate the transmission dipstick. In most models, you will find the dipstick at the rear and to the side of the engine. Some transmissions have a dipstick handle marked with the words Transmission Oil, or come with a rounded, orange-colored handle. Pull the dipstick and wipe clean the tip with a clean shop rag. Insert the dipstick back into its guide tube. Pull the dipstick again, hold the tip on a clean shop rag and inspect the oil at the tip. The oil should be clear with a reddish color to it. If the oil looks dirty or smells burned, change the transmission oil. Look at the oil closely and make sure there are no metal, dirt, moisture or fiber particles in it. These particles might come from internal parts' wear. If left in the oil, these particles may accelerate parts' wear and even cause transmission failure. Change the transmission oil if it is contaminated. Make sure the level of the oil in the dipstick reaches the full mark. If the oil is between the Add and Full mark, add only half a quart of the manufacturer recommended transmission oil. If the oil is at the Add mark, add a quart of oil. Add oil through the dipstick guide tube using a funnel and check the oil level again. Replace the dipstick in the guide tube, close the hood and turn off the engine.

Changing Honda manual transmission fluid is not a difficult task in my opinion. This is why you should change your filter—as well as your ATF—every 25,000 miles. Once you place an order, you or someone you know can pick it up at a Sears store, have it shipped to over 100 countries—whatever is most convenient for you. If you favor automatic transmissions, automatic transmission fluid ATF has the ability to function effectively under a wide range of operating temperatures. This article applies to the Honda Civic 1992-2000. At AutoZone, you can find top-grade transmission fluid, so you don't have to worry about any worn-out gears while you're shifting. The oil should be clear with a reddish color to it. Pull the dipstick and wipe clean the tip with a clean shop rag.

Free VBA Training Course

※ Download: Learn vba for excel

After getting the recorded macro, you could check its object model then, learn related methods or properties from and modify them based on your requirement. The Visual Basic Editor appears. Not only that, it introduced me to VBA concepts I had no idea were even possible! VBA procedures developed in the VBE become part of the workbook in which they are developed and when the workbook is saved the VBA components including macros, modules, userforms and other components that you will discover in the next 32 lessons are saved at the same time.

You have run the macro from the menu bar of Excel. The end result is illustrated in the image below. We highly suggest you also do the included exercises.

VBA Tutorial - You will develop, test and modify VBA procedures macros in the Excel Visual Basic Editor VBE.

As humans, we are creatures of habit. There are certain things that we do on a daily basis every working day. Wouldn't it be better if there were some magical way of pressing a single button and all of our routine tasks are done? I can hear you say yes. In a nutshell, a macro is the magical single click button. We will cover the following topics in this tutorial. A macro is a piece of programming code that runs in Excel environment and helps automate routine tasks. In a layman's language, a macro is a recording of your routine steps in Excel that you can replay using a single button. The importance of macros in Excel Let's say you work as a cashier for a water utility company. Some of the customers pay through the bank and at the end of the day, you are required to download the data from the bank and format it in a format that meets your business requirements. You can import the data into Excel and format. The following day you will be required to perform the same ritual. It will soon become boring and tedious. Macros solve such problems by automating such routine tasks. What is VBA in a layman's language? VBA is the acronym for Visual Basic for Applications. It is a programming language that Excel uses to record your steps as you perform routine tasks. You do not need to be a programmer or a very technical person to enjoy the benefits of macros in Excel. Excel has features that automatically generated the source code for you. Read the article on Vba for more details. Macro Basics Macros are one of the developer features. By default, the tab for developers is not displayed in excel. You will need to display it via customize report Macros can be used to compromise your system by attackers. By default, they are disabled in excel. Always fill in the description of the macro when creating one. This will help you and others to understand what the macro is doing. Step by step example of recording macros in Excel We will work with the scenario described in the importance of macros excel. We will work with the following CSV file. You can download the above file here We will create a macro enabled template that will import the above data and format it to meet our business reporting requirements. Enable Developer Option To execute VBA program, you have to have access to developer option in Excel. Enable the developer option as shown below and pin it into your main ribbon in Excel. Now that we have finished our routine work, we can click on stop recording macro button as shown in the image below Before we save our work book, we will need to delete the imported data. We will do this to create a template that we will be copying every time we have new receipts and want to run the ImportBankReceipts macro.

Close the VBE and close Excel without saving anything. I would actually like to continue with part II. The Code Window is where 90% of the VBA work is done; writing VBA sentences, testing your VBA procedures macros and learn vba for excel them when needed. You will find at least half a dozen very good forums where someone will have asked the same question before. Section 1: Programming in Excel Macros Here are samples of what you will find in Section 1 of the downloadable Print this page to read it at home, at the office, on the bus or the train Excel Macros Section 1: Programming Macros in Excel In this first section you will learn learn vba for excel easy it is to record macros with the Macro Recorder and to create other macros of your own in the Visual Basic Editor. Defining Variables, Constants, and Calculations 2. VBA is a great language to start with because you can master the fundamentals of programming in a familiar work environment. This VBA tutorial will teach you the basics of using VBA with Excel. If you have any issues when developing with Office Object Model, please feel free to post threads on this forum.