Quake3World.com
https://www.quake3world.com/forum/

Excel Programming (VBA)
https://www.quake3world.com/forum/viewtopic.php?f=13&t=604
Page 1 of 1

Author:  Pext [ 02-17-2005 02:13 AM ]
Post subject:  Excel Programming (VBA)

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.

Author:  Guest [ 02-17-2005 03:49 AM ]
Post subject: 

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.

Author:  Pext [ 02-17-2005 05:41 AM ]
Post subject: 

thanks a lot.

btw - i just found a nerd joke.

Code:
Dim sum ...


:icon19:

Author:  Shmee [ 02-21-2005 05:51 PM ]
Post subject: 

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?

Author:  U4EA [ 02-21-2005 11:37 PM ]
Post subject: 

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.

Author:  Shmee [ 02-23-2005 07:29 AM ]
Post subject: 

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

Author:  Guest [ 02-23-2005 10:15 PM ]
Post subject: 

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

Author:  U4EA [ 02-24-2005 12:21 AM ]
Post subject: 

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

Author:  Tormentius [ 02-24-2005 12:28 AM ]
Post subject: 

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.

Author:  Guest [ 02-25-2005 02:15 PM ]
Post subject: 

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

Page 1 of 1 All times are UTC - 8 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/