Quake3World.com Forums
     Technology & Troubleshooting
        Excel Programming (VBA)


Post new topicReply to topic
Login | Profile | | FAQ | Search | IRC




Print view Previous topic | Next topic 
Topic Starter Topic: Excel Programming (VBA)

Who's that man, Mommy?
Who's that man, Mommy?
Joined: 27 Aug 2003
Posts: 5189
PostPosted: 02-17-2005 02:13 AM           Profile Send private message  E-mail  Edit post Reply with quote


As i'm currently doing some research in prime numbers, i decided to collect some data i need for my maths with excel, as it allready includes a good ways to represent the data after creating the numbers (colouring certain cells, etc...).

But as i don't know shit about vba - and as google is full of payed ad-links when it comes to excel - it'd be nice if someone could point me to a free internet resource on vba programming. I allready know C and Java btw, so i dont need general programming info ...

Things i need to know:

1 - how are simple functions implemented for excel/basic.
something like:
Code:
void bla(int x, string y)
{
    // - code -
}


2 - how to access (in/out) a certain cell in a certain document by its index

hm... i think that's all.




Top
                 

PostPosted: 02-17-2005 03:49 AM           Profile Send private message  E-mail  Edit post Reply with quote


Getting ready for work so I gotta make this quick.

vbcity

Check that place out. It's been very helpfull for me. There's a forum specifically for VBA and excel.




Top
                 

Who's that man, Mommy?
Who's that man, Mommy?
Joined: 27 Aug 2003
Posts: 5189
PostPosted: 02-17-2005 05:41 AM           Profile Send private message  E-mail  Edit post Reply with quote


thanks a lot.

btw - i just found a nerd joke.

Code:
Dim sum ...


:icon19:




Top
                 

Paragon of Cruelty
Paragon of Cruelty
Joined: 14 Feb 2005
Posts: 443
PostPosted: 02-21-2005 05:51 PM           Profile Send private message  E-mail  Edit post Reply with quote


vb is almost counter intuitive if you know any "real" (for want of a better term - don't crucify me if you worship VB) languages.

I mean, functions.... come on. No return? Small children can easilly understand the concept. What's with setting the function name equal to the result?



_________________
You're Pretty When I'm Drunk


Top
                 

i liek boobies
i liek boobies
Joined: 26 Nov 2000
Posts: 11930
PostPosted: 02-21-2005 11:37 PM           Profile Send private message  E-mail  Edit post Reply with quote


Not a VB worshipper but it definitely has its uses. I'm not overly familiar with VB6 as I only used it for one uni project, but I've been professionally using VB.NET for our GUIs for a year now and it's pretty damn solid. Gets rid of a lot of old VB6 inconsistencies and crap, adds OO support not to mention .NET libraries and countless other improvements.




Top
                 

Paragon of Cruelty
Paragon of Cruelty
Joined: 14 Feb 2005
Posts: 443
PostPosted: 02-23-2005 07:29 AM           Profile Send private message  E-mail  Edit post Reply with quote


Oh yeah - to be sure. I was knocking the old VB6 and back. .Net is pretty much an improvement on everything.



_________________
You're Pretty When I'm Drunk


Top
                 

PostPosted: 02-23-2005 10:15 PM           Profile Send private message  E-mail  Edit post Reply with quote


How much different is VB.NET than VB6? Would there be a large amount of relearning?




Top
                 

i liek boobies
i liek boobies
Joined: 26 Nov 2000
Posts: 11930
PostPosted: 02-24-2005 12:21 AM           Profile Send private message  E-mail  Edit post Reply with quote


As I said, I'm not too familiar with VB6 but I'd guess a fair amount of learning would be in order.




Top
                 

The voices in your head
The voices in your head
Joined: 14 Dec 2002
Posts: 10054
PostPosted: 02-24-2005 12:28 AM           Profile   Send private message  E-mail  Edit post Reply with quote


U4EA wrote:
As I said, I'm not too familiar with VB6 but I'd guess a fair amount of learning would be in order.


Yeah, I'd say quite a bit.




Top
                 

PostPosted: 02-25-2005 02:15 PM           Profile Send private message  E-mail  Edit post Reply with quote


What I was afraid of. Well, back to the books.....




Top
                 
Quake3World.com | Forum Index | Technology & Troubleshooting


Post new topic Reply to topic


cron
Quake3World.com
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group