Microsoft Office Automation – Automating Internet Explorer (Add Dom Navigation)

This post has been moved to my new tutorials blog (article found at http://marcphillipstutorials.blogspot.com/2013/07/automating-internet-explorer-add-dom.html). Take some time to look around!

Microsoft Office Automation – Automating Internet Explorer (Add IE Controls)

This post has been moved to my new tutorials blog (article found at http://marcphillipstutorials.blogspot.com/2013/07/automating-internet-explorer-add-ie.html). Take some time to look around!

Microsoft Office Automation - Automating Internet Explorer (Setup)

This post has been moved to my new tutorials blog (article found at http://marcphillipstutorials.blogspot.com/2013/07/automating-internet-explorer-setup.html). Take some time to look around!

Microsoft Office Automation - Introduction

Nobody likes to do repetitive tasks, especially when time is lost as a clunky html page is required to load between each step. Wouldn’t it be great to automate some of the things you do every day without ever having to see the webpage you are trying to reach? This is the power of automation – reducing the time it takes to perform repetitive tasks by letting a computer (a machine that is designed around repetition) to do it for you.

The problem many face when attempting to automate is the barrier of code and logic. It is not uncommon to hear that one must place 10,000 hours into a coding language before they are capable of writing their own automation scripts. Many wish that there was a simple step-by-step tutorial on how to automate their particular tasks that didn’t require this long and arduous learning curve. The problem is that many of the instructions or forums are written for people who have coding experience, or who have at least a basic understanding of the language.

This is where my blog posts will come in. Over the course of the next several posts I will outline how to automate the Microsoft Office Suite using Visual Basic for Applications. As these articles are written, you can check back here and click on any one to get a further in-depth explanation as to how this can be done. Each post will be written in an attempt to explain concepts to the uninformed, and to make it as easy as possible so that even non-technical users will be able to create their own automation suite.

The majority of this code will be taken from my project to automate purchase tracking during my internship at Adobe. The entire project will be uploaded to this page (after much editing to remove any Adobe information has been completed). Feel free to download it and run it for yourself.

Initially these posts will be a little more technically minded simply because I want to get out the harder concepts before I forget what I have done and my justification behind those actions. After this is complete, I intend to add more explanation for non-techies, and then to write a few posts explaining some common concepts used in this macro.

**A quick note on this process – it is not professional grade coding, and it was never intended to be so. Some other programmer may be able to write something that is more stable, more reusable, and more robust than this. These blog posts are intended to show you what works. If you have questions about how to find information on the web concerning automation, read my other post about searching for useful answers on the web.

Obligatory Gratitude

This past Sunday during church we had a lesson on gratitude. The comment was made that service is designed to make us grateful for the things that we have. Comments like these have always been given in church without much thought or remark, almost as though this was a given fact. However this time I noticed what was being said and thought about the ramifications behind that statement. After jotting my thoughts down on paper I handed it to my roommate Jake who was sitting next to me. The following is written conversation that Jake and I had about gratitude:

Me: Isn't there something inherently wrong with the idea that service is supposed to make us grateful for what we have? Isn't that like saying you serve to realize you have it better than someone else? It almost seems that it boils down to the concept of competition - I serve to realize that I'm better than others.

God does not want us to serve so we realize He has blessed us more; He wants us to serve because we realize beforehand that we have been blessed for the intent of blessing others.

{I can see a flaw in this idea as well}

Jake: How?

Me: 1) Did God bless us only for the intent to bless others? If so, why doesn't He just bless everyone?  2) Is it really being gracious if we follow the commandment to bless others? Shouldn't gratitude be given freely?}

Jake: In reply to 1) I think God did bless us so we could bless others. By blessing others we are able to garner chartiy, etc. In the end, we will be gods and this gives us an opportunity to practice blessing others.

In reply to 2) It depends on your motives. It's not altruistic if you're doing it based on command. How does one give gratitude?

Me: In response to Jake's reply to 1) I agree He blessed us to bless others for that reason, but does that mean we are showing gratitude when we serve others because of this blessing? It seems like doing service for this reason is done not because of gratitude, but for obedience. Since this is the case, the response to 2) is that gratitude is expressed without obligation or external pressure. Though we are commanded to be grateful, one cannot be grateful if obligated to do so. It must come from our own will and desire.

Jake: So are you saying it's not pure to serve others for the purpose of expressing gratitude for our blessings? Do people really feel obligated to serve others when feeling gratitude? Possibly, but I feel people want to bless others when they are grateful for what they have and they want others to have the same blessings.

Me: I think it is possible to serve out of gratitude and that many serve because they want others to have what they have. However, to say that we must serve to show gratitude is fallacious because it wouldn't be gratitude but instead it would be obedience. As soon as one serves out of obligation instead of gratitude they have lost the ability to show gratitude in that service. Gratitude can compel a man to serve, but obligation cannot create gratitude. A man can be obedient and still show gratitude though his service, but the obedience must just be a natural consequence of his actions expressing his gratitude and not his motivating factor.

Fin
_______________________
This was the conversation we had. I found it interesting to notice very strong Kantian ideals and logic in my arguments. I have just finished reading his book "Metaphysical Principles of Virtue" where he lays the foundation for the categorical imperative. Clearly he has had a profound affect on my thought process.

Any thoughts or comments on the above conversation would be greatly appreciated. Feel free to tear it apart - I would love to know where this logic is wrong or what you think.

People Do Weird Things

Lately I have spent a lot of time on the internet viewing some of the user content that people tend to post on such sites as youtube and facebook. The majority of the time what people decide to be funny or creative is actually just mildly interesting at best, like a Suzanne Collins book.

However, there are sometimes things that just don't make any sense. Some people just don't think like me at all. The creation of this video is very much evidence of this fact:

What would possess a human to think of such a dance? In conjunction with the conception of this weirdness, can you consider the dancers who actually performed this, what they were thinking when they were hired on for the job? I can only imagine them thinking: I am only doing this because I am tired of dumpster diving for my morning bagel. Poor artists, they make so little money that they are forced to these lengths.

But occasionally there are things that people find funny that are in actuality just plain dull. Take this video for example:

What is so funny about a bunch of cows being attracted to a Jazz Band that it is actually worth the time of almost a million people to watch? I don't get it, and I am pretty sure that the cows don't either.

Introduction

I feel as though these little introduction posts are, for the most part, a necessary evil that each blogger must provide. As cliche as it sounds, you need to know about me before you read my writing. Unless you feel that you have a firm grasp of my psyche and thought patterns, I would recommend taking a minute reading this lest you decide to never visit this site again.

This blog has been a long time in the making. Indeed, many in my life, especially the friends in my ward, have asked me for months to start a blog. For whatever reason they think that I will be able to provide some sort of distraction in their lives that will be more valuable then Facebook or Kid History (which is a great compliment considering the undeniable quality of said production). Therefore, this blog is first and foremost meant for distraction and enjoyment by its readers and not meant as an avenue to truly express my opinions. It is true that one's opinions are hard to hide when speaking on a subject, but I encourage you to think that perhaps my posts are meant to be entertaining and therefore not necessarily my true opinions.

And why would I need to say that, do you ask? Because often times I am not really sure what my opinions are. So if I post something that may be slightly offensive to someone because it casts a less than pristine opinion of their favorite TV show or may be offensive to the 1/100th part Cherokee they have in their blood, know that it was not meant to be a slight to your existence. In fact, realize that this is not a politically correct blog, and I am diametrically opposed to the ideology. In a day and age of supposed "enlightened" thought and "freedom" of speech, it certainly seems that we are limited to what we may or ought to say.

This being said, I do not intend to make this an offensive blog, or even a blog that will deal with many volatile subjects. I just would like it if you didn't post a comment about how you will find me in the night and make me pay for my arrogance over a post I have written. In reality, you have taken me and my little digital corner of the universe WAY to seriously, and you probably need help. I have provided a link for you, please take time to peruse its pages before hunting me down. Thank you.