<![CDATA[Christian Furs - Christian Furry Community

<![CDATA[Christian Furs - Christian Furry Community - Computers and Gadgets]]> http://christianfurs.net/ Fri, 03 Sep 2010 06:26:42 +0000 MyBB <![CDATA[Visual Basic for Applications]]> http://christianfurs.net/thread-1369.html Tue, 13 Apr 2010 21:08:26 +0000 http://christianfurs.net/thread-1369.html
Visual Basic for Applications is what I'm learning in school right now. It's a pretty simple language, but also a bit of a useless one. But, it's an interesting introduction to programing. I've actually been having a bit of fun with it.

So, what VBA is, is a language mostly used in scripting Microsoft Office. However, it is used for other programs as well.
What the class I'm in, and what this thread will try to do, is teach how to script Office to do things it's not meant to do.

VBA in office is a bit of a controversial topic, because there's some people who think its great and want to keep it in future versions of Office, others that think its horrid and a tremendous security risk, and 90% of the users who didn't even know it existed.
Its also a very old function of Office. This aspect of the software has not changed at all since Office 97 came out. The book we're using in class was written in 2000 and is still applicable today.

So, let's get started with some basics.
Obviously, you will need Microsoft Office. Just about any version will do, I'm using 2007 myself so everything here will be based on that.

First, we need to tweak some settings.
Go ahead and open up Word. Click the Office button, then "Word Options".
Once there, click the checkbox next to "Show Developer tab in the ribbon" and click OK. This will give you a new tab in all Office applications.

The first thing we'll do, is record a simple macro. A macro is a script that automates something.

Click the Developer tab on the ribbon, and in the Code group, you should see "Record Macro". Go ahead and click that, and click OK on the box that comes up.
You are now recording your actions within the document.
Now, type "This is my first macro"; hit "Stop Recording" on the ribbon.
Click "Macros" in the Code group on the ribbon, a box should come up showing what macros you have recorded.
Click on the macro we just made to select it, it should be named Macro1. Click "Edit" off to the right.

This should bring up a VB editor window and the code that generates the macro we just recorded.
Let's take a look at the macro.

Code:

Sub Macro1()

'

' Macro1 Macro

'

'

    Selection.TypeText Text:="This is my first macro"

End Sub

So, what is going on here?

Code:

Sub Macro1()

This indicates that we have a sub procedure, and that the name of that procedure is "Macro1".

Code:

'

' Macro1 Macro

'

'

This is a comment, it does nothing. It tells whoever is looking at the code what it is. Comments can be anything, and I'll show you more later.

Code:

Selection.TypeText Text:="This is my first macro"

This is what our macro is actually doing. It's typing text ("typetext") into the selection (where the cursor is), and the text it typed was "this is my first macro". Pretty simple, isn't it?

Code:

End Sub

End of the macro.

So, lets have some fun with this. In the VB editor here, we can tweak our macro to do other things.

Lets have it come up with a little message box saying it was successful.
The code for a message box is pretty simple. Start by entering the following:

Code:

Selection.TypeText Text:="This is my first macro"

    msgbox

When you hit space after typing "msgbox", you will see a little help popup. So, lets continue on.

Code:

msgbox "Great Success!",

After you put the , at the end, another list of options will come up showing what kind of buttons we want on our box. The default is "okonly", so we can simply put another comma here. I would encourage you to play around with the different options here and see what they do.
Lets continue

Code:

msgbox "Great Success!",,"woot"

With this, "woot" will be shown as the title of our message box. This is optional of course.
We won't worry about the other options for now. Hit the enter key and review your code.

Code:

Sub Macro2()

'

' Macro2 Macro

'

'

    Selection.TypeText Text:="This is my first macro"

    MsgBox "Great success!", , "Woot"

End Sub

To test it, simply hit F5 on your keyboard.

So, I'll leave that as our first lesson. I'll see how well this thread goes over before posting more.]]>
Visual Basic for Applications is what I'm learning in school right now. It's a pretty simple language, but also a bit of a useless one. But, it's an interesting introduction to programing. I've actually been having a bit of fun with it.

So, what VBA is, is a language mostly used in scripting Microsoft Office. However, it is used for other programs as well.
What the class I'm in, and what this thread will try to do, is teach how to script Office to do things it's not meant to do.

VBA in office is a bit of a controversial topic, because there's some people who think its great and want to keep it in future versions of Office, others that think its horrid and a tremendous security risk, and 90% of the users who didn't even know it existed.
Its also a very old function of Office. This aspect of the software has not changed at all since Office 97 came out. The book we're using in class was written in 2000 and is still applicable today.

So, let's get started with some basics.
Obviously, you will need Microsoft Office. Just about any version will do, I'm using 2007 myself so everything here will be based on that.

First, we need to tweak some settings.
Go ahead and open up Word. Click the Office button, then "Word Options".
Once there, click the checkbox next to "Show Developer tab in the ribbon" and click OK. This will give you a new tab in all Office applications.

The first thing we'll do, is record a simple macro. A macro is a script that automates something.

Click the Developer tab on the ribbon, and in the Code group, you should see "Record Macro". Go ahead and click that, and click OK on the box that comes up.
You are now recording your actions within the document.
Now, type "This is my first macro"; hit "Stop Recording" on the ribbon.
Click "Macros" in the Code group on the ribbon, a box should come up showing what macros you have recorded.
Click on the macro we just made to select it, it should be named Macro1. Click "Edit" off to the right.

This should bring up a VB editor window and the code that generates the macro we just recorded.
Let's take a look at the macro.

Code:

Sub Macro1()

'

' Macro1 Macro

'

'

    Selection.TypeText Text:="This is my first macro"

End Sub

So, what is going on here?

Code:

Sub Macro1()

This indicates that we have a sub procedure, and that the name of that procedure is "Macro1".

Code:

'

' Macro1 Macro

'

'

This is a comment, it does nothing. It tells whoever is looking at the code what it is. Comments can be anything, and I'll show you more later.

Code:

Selection.TypeText Text:="This is my first macro"

This is what our macro is actually doing. It's typing text ("typetext") into the selection (where the cursor is), and the text it typed was "this is my first macro". Pretty simple, isn't it?

Code:

End Sub

Code:

Selection.TypeText Text:="This is my first macro"

    msgbox

When you hit space after typing "msgbox", you will see a little help popup. So, lets continue on.

Code:

msgbox "Great Success!",

Code:

msgbox "Great Success!",,"woot"

With this, "woot" will be shown as the title of our message box. This is optional of course.
We won't worry about the other options for now. Hit the enter key and review your code.

Code:

Sub Macro2()

'

' Macro2 Macro

'

'

    Selection.TypeText Text:="This is my first macro"

    MsgBox "Great success!", , "Woot"

End Sub

To test it, simply hit F5 on your keyboard.

So, I'll leave that as our first lesson. I'll see how well this thread goes over before posting more.]]> <![CDATA[I'm getting an iPod Touch!]]> http://christianfurs.net/thread-1348.html Wed, 07 Apr 2010 22:28:17 +0000 http://christianfurs.net/thread-1348.html ! I'm getting an 8 gb 3G, and I can't wait! Do you think it's worth the $176 I'm paying for it, and if you have one, what ups and downs do they have?]]> ! I'm getting an 8 gb 3G, and I can't wait! Do you think it's worth the $176 I'm paying for it, and if you have one, what ups and downs do they have?]]> <![CDATA[Facebook virus]]> http://christianfurs.net/thread-1290.html Thu, 18 Mar 2010 20:06:50 +0000 http://christianfurs.net/thread-1290.html
Hackers are sending out a mail saying your password has been changed, in it is a link, DONT CLICK IT.

If you do they get every password on your computer, even banking passwords.

Heres a link to a news place about it: http://www.reuters.com/article/idUSTRE62G5A420100318]]>
Hackers are sending out a mail saying your password has been changed, in it is a link, DONT CLICK IT.

If you do they get every password on your computer, even banking passwords.

Heres a link to a news place about it: http://www.reuters.com/article/idUSTRE62G5A420100318]]> <![CDATA[The ipad. Awesome or Pointless? Or Both?]]> http://christianfurs.net/thread-1189.html Sun, 07 Feb 2010 06:55:19 +0000 http://christianfurs.net/thread-1189.html <![CDATA[Windows 7]]> http://christianfurs.net/thread-936.html Fri, 23 Oct 2009 06:26:22 +0000 http://christianfurs.net/thread-936.html And... its... meh... to be honest.
I don't really see much of an improvement over XP or Server 2008 (the last two Windows systems I used). It leaves me longing for something more... I think I still prefer Linux.
It broke my bootloader too, so I can't get back to Linux right now. I'm not exactly happy about that.
Oh well. I have it. I paid $30 for it.

What do you guys think?]]> And... its... meh... to be honest.
I don't really see much of an improvement over XP or Server 2008 (the last two Windows systems I used). It leaves me longing for something more... I think I still prefer Linux.
It broke my bootloader too, so I can't get back to Linux right now. I'm not exactly happy about that.
Oh well. I have it. I paid $30 for it.

What do you guys think?]]> <![CDATA[Linux]]> http://christianfurs.net/thread-929.html Tue, 20 Oct 2009 15:58:17 +0000 http://christianfurs.net/thread-929.html <![CDATA[SPAH'S SAPPIN' MAH ICECHAT!]]> http://christianfurs.net/thread-475.html Tue, 28 Apr 2009 18:02:29 +0000 http://christianfurs.net/thread-475.html <![CDATA[MSN Accounts being comprimised]]> http://christianfurs.net/thread-425.html Wed, 08 Apr 2009 06:43:36 +0000 http://christianfurs.net/thread-425.html The first sent me two messages on two different days with a link (in the first one) or a list of links (in the second one). Both ask for privet information.
The second sender's first message was almost like the first's second message. Just an array of links that went to a different web site. Still asked for MSN login details.

If you are in my friends list, I will report this to you if it happens. If it happens to me, please tell me as soon as possible.

Much appreciated.]]> The first sent me two messages on two different days with a link (in the first one) or a list of links (in the second one). Both ask for privet information.
The second sender's first message was almost like the first's second message. Just an array of links that went to a different web site. Still asked for MSN login details.

If you are in my friends list, I will report this to you if it happens. If it happens to me, please tell me as soon as possible.

Much appreciated.]]> <![CDATA[Connecting to IRC channels in Icechat]]> http://christianfurs.net/thread-265.html Sun, 15 Feb 2009 04:33:04 +0000 http://christianfurs.net/thread-265.html
Open Icechat

Left click on one of the servers in "Favorite Servers" list (it doesn't matter which one)

Click "Add New Server..." and put "freejavachat.com" in the box.

Click "Next" twice and put "#cff" in the box.
Click "Next" and fill in your default nick
Click "Next" 2 more times. You should see

Fill in your alternate nick (name_ for example)
Fill in your away nick (name_away for example)
If your nick is registered, click "Startup" and fill in the Nickserv password.
Click "Save"

Next time you open up Icechat, just double click on "freejavachat.com" on the side.

While you're at it, Click "Icechat Editor" (blue circle with a star) and add this line to the bottom

Code:

/rand /say $randquit

Click "Save and Exit"
Type "/rand" in a chat and see what happens.]]>
Open Icechat

Left click on one of the servers in "Favorite Servers" list (it doesn't matter which one)

Click "Add New Server..." and put "freejavachat.com" in the box.

Click "Next" twice and put "#cff" in the box.
Click "Next" and fill in your default nick
Click "Next" 2 more times. You should see

Code:

/rand /say $randquit

Click "Save and Exit"
Type "/rand" in a chat and see what happens.]]> <![CDATA[Google does what?]]> http://christianfurs.net/thread-198.html Wed, 28 Jan 2009 05:22:43 +0000 http://christianfurs.net/thread-198.html [Image: gbot.JPG]

]]>

]]> <![CDATA[Computer Specs]]> http://christianfurs.net/thread-104.html Sat, 03 Jan 2009 08:30:52 +0000 http://christianfurs.net/thread-104.html So, what kind of computer do you use? Mac, PC, iphone... Tell us about it! Here's your chance to brag about what you have, or whine about what you wish your computer could do.

Updated: 02/01/2010
So, to start:
I use a couple of different computers, but I mainly alternate between my desktop and a laptop. On the desktop side, I've built a whirring monolith that is as follows:
Antec P182 Case (monolith)
Asus P5NE-SLI Motherboard
Intel Core 2 Duo 2.6Ghz, Overclocked to 3.16Ghz (whirring)
6Gigs of Ram, which it sees all of. Big Grin

An NVidia 8800 GT drives my 1080P monitor and one 1280x1024, and an NVidia 9400 drives the other 1280x1024 and a 1024x768. Yes, I use all of them.

On the laptop side, I switch between my luggable Lenovo Y410, for the power work, and my Asus eeePC 1000h, for note-taking and casual surfing. The eee's specs are pretty standard:
1.6Ghz Intel Atom Processor
2Gb of RAM
80 GB Hard drive (Which I need to upgrade)
The battery, however, lasts a good 5 hours in use. Very nice for long classes.
The Lenovo:
Core 2 Duo Centrino @1.6Ghz
2 Gigs of Ram
320GB Hard drive
Integrated video. Sad

Well, that's it. Now, show everyone what you use!]]> So, what kind of computer do you use? Mac, PC, iphone... Tell us about it! Here's your chance to brag about what you have, or whine about what you wish your computer could do.

Updated: 02/01/2010
So, to start:
I use a couple of different computers, but I mainly alternate between my desktop and a laptop. On the desktop side, I've built a whirring monolith that is as follows:
Antec P182 Case (monolith)
Asus P5NE-SLI Motherboard
Intel Core 2 Duo 2.6Ghz, Overclocked to 3.16Ghz (whirring)
6Gigs of Ram, which it sees all of. Big Grin

Well, that's it. Now, show everyone what you use!]]>