I've always been interested in computers and enjoy using a computer to solve problems. To this end I am always writing little macros to make the process easier. I usually, though not always, use the visual basic editor in Excel, which provides everything you need (and more).
I'm not intending to write a manual to teach you Visual Basic here, but only provide a simple vision of what it means to automate a task in this way. I will do this by describing whatI want to do and then how I solved the problem.
I want to do.
I am an internet marketer and often want to change the text or I count the characters, etc. Visual Basic If I publish an article, Visual Basic a number of publications will allow a different number of characters or words for keywords, synthesis, and the same item. I find myself with a sheet with a list of keywords and not only know if I have too many keywords or could host another 1 or 2. Visual Basic When Ito add some keywords or tags to any bookmark then I might want to add quotes around phrases to replace a word or comma delimiter with a space delimiter. Can I have a string of keywords separated by a comma and a space for such a word, 2 word and all I want to do is replace the surplus space after each comma. Replacing each comma by comma space only then I will reduce the number of characters in the string and can include another keyword. If I do not know who or how many keywordsthe number of characters that are then perhaps failing to use the largest share.
How I solved the problem.
Now I wrote a small macro in Excel using Visual Basic Editor. A macro is a small computer program that you can start Excel by pressing the keys. I wrote lots of macros to perform complex tasks, but this routine is very simple. When you use Excel, you can view the source code of a macro via the Tools, Macro, and VisualBasic Editor tabs. If you've never understood what is a macro, then you will find this interesting to see how the statements are written. My routine now has 3 buttons to perform three basic tasks. The easiest job is to erase all data so you can start over. Visual Basic I added another button to replace a string with another string and a button to provide me with a string in which each keyword or keyword phrase is wrapped in quotation marks.
If you use a computer dailyto perform a series of tasks in your quest to become a successful internet marketer then you'll quickly realize how life could be much easier if it were possible to automate some of the simplest of tasks. Another example of a little work I have automated is the ability to record and manipulate statistical data. When I review a site for which I am a member I can copy a string of data that tells me the number of clicks and other information that I received today. Visual Basic I then paste the informationdirectly into a spreadsheet and then have a macro to present information in a way that is most useful for me. That way I can automatically record a time and calculate the number of days since I last checked the site and more.
You can access this little routine from my site by following a link.
shooter games buy kid games zone
No comments:
Post a Comment