Monthly Archives: May 2013

WordPress Video Plugin – the Solution to When YouTube Will Not Embed in WordPress

Posted on by

In my last post, I embedded a youtube video. It proved to be surprisingly tricky.  I ended up having to use the WordPress Video Plugin.

One is usually supposed to use the html iframe tag to do this:

<iframe width="560" height="315" src="http://www.youtube.com/embed/-iFeC7R3Tfg" frameborder="0" allowfullscreen></iframe>

or a WordPress shortcode like this:

[youtube=http://www.youtube.com/embed/-iFeC7R3Tfg&w=560&h=315]

It turns out, neither of these worked. Instead, I used the WordPress Video Plugin. This is easy to do. If you know how to administrate WordPress, click on “Plugins->Add New”. Then search for “WordPress Video Plugin”. When you find it, click on “Install Now”. After it installs, click “Activate”.

After you have finished installing and activating it, in order to embed a youtube video, use the following format:

[youtube id]

where id is the identification youtube uses to uniquely identify the video.  If you look at the failed attempts above, it would be the part in bold.

[youtube=http://www.youtube.com/embed/-iFeC7R3Tfg&w=560&h=315]

Causing the use of the WordPress Video Plugin to embed the video from the last post to look like this:

[youtube -iFeC7R3Tfg]

You can find details about how to embed other videos using the WordPress Video Plugin here.

VBA’s Very Handy but Little Known Debug.Print

Posted on by
1

This entry is going to be quite short.

Tired of endless Message Boxes when trying to discover the flaw in your code? Try the wonderful but surprisingly little known VBA command Debug.Print. This is a VBA command that I have used for years. I was recently surprised to discover that several of my friends who use VBA professionally did not know about it.
When debugging your VBA code, it always nice to follow the values of your variables and functions to try to discover the source of the problem. There are many ways to do this.
Message Boxes (Command: msgbox) have their uses but if you are trying to track the value of a loop counter they become extremely annoying very quickly. Having to click OK 40 times really gets on one’s nerves.

Say hello to Debug.Print

It’s an extremely simple command. Anywhere in your code, just type “Debug.Print” and the variable or function that you want afterwards. You can even customize it with a string.

Example

Sub TestDebugDotPrint()
Dim lngTroublesomeVar as long
lngTroublesomeVar = 22
Debug.Print “The lngTroublesomeVar is: “ & lngTroublesomeVar
End Sub

If you look at the immediate window in the VBA IDE

(if you can’t see it, click View->Immediate Window or type Ctrl-G),

you should see:

The lngTroublesomeVar is: 22

Use it for all of your debugging needs!