Cool Excel VBA code, any ideas?

[CoolTech]

What are some cool aspects I could use to implement some VBA code? In one of my classes that I use Excel, the teacher has a contest among students and whoever has the best project will get a letter grade increase( B to A), any cool ideas I can incorporate into my VBA code?

 

[CoolTech]

bump

 

[KeyserSoze]

I don't know if this is exactly what your talking about, but you could download "Microsoft Agents." They are little characters that can be coded to respond to VBA commands. You would have to install some programs to make them work first.

Here are a few sites that I found randomly with Google. It is NOT hard to learn, and I'm sure I could help you with some of it if you wanted.

Click Me
Click Me (PDF File)


Basically, you would have to install the characters, and their speech engines. Then the animation, and making them talk is REALLY easy. This would definitely be "cool" to incorporate for some project like this.




KeyserSoze

 

[CoolTech]

bump

 

[CoolTech]

bump

 

[KingNothing]

If Windows Scripting Host is installed on the computers, and antivirus protection is not, you could always write some code to execute a script that [use your imagination here, the possibilities are endless].

Not sure what kind of options VBA gives you for entertaining activities.

 

[michaelh20]

How about your very own word virus?

 

[CoolTech]

bump

 

[Hector13]

I don't know what your project is and your question is way to vague for a useful answer. but why don't you try connecting your excel app to a database in access (using ADO or somesuch). Or you could have excel trigger a mass mail merge from outlook (or send some sort of "confirmation" email or "error" email through outlook).

 

[CoolTech]

ok, this is what I have to do:

I have a linear programming model in which three different auditors, John, Bill, and Michelle will be chosen for certain projects. certain constraints you will be able to change, like their salary for projects 1,2, and 3 as well as the available hours they have to work and required hours for each project.

One userform or multiple userforms will take these values using Excel solver and find the optimal solution which will maximize profits, here is what I have so far. Let me know what you think.

I have pictures of three of my professors that I want to display in the middle of the form. Whenever I click the button on the left corresponding to their name and click their picture, a box will come up to input for me to change their parameters (salary for project 1, salary for project 2, salary for project 3, and hours available to work)

I have a class competition for a grade boost for this, any ideas would help me out. He doesnt care if we get help or what outside code we uses, he just said give em' hell. Competition seems to be somewhat fierce. Please help or point me in a direction that may help me more. Thanks!

I can add graphs, images, whatever. marketing is the most important aspect of the project since the class votes on it. So whatever pizzazz you can suggest would be great. thanks.

 

[CoolTech]

bump

 

[CoolTech]

bump

 

[de8212]

although I can't help, you may want to go to http://www.mrexcel.com/board2/ and search or ask.


de

 

[Hector13]

if it is a linear program, why not code up your own simplex algorithm. You can have some "cool" diagnostic data spit out as your "optimizer" is plugging away (ie, what pivots are taken).