VCE Stuff > VCE Computing: Data Analytics
EXCEL Static Date Stamps
excal:
I have plenty, but they're not my intellectual property :P
But I'm working on this: Monash University eAdmissions
aidansteele has written a fair few things though...the combubulator and various other things
He also does this in his spare time: Komodo CMS
excal:
--- Quote from: Mao on August 15, 2008, 08:13:08 pm ---Visual Basics is worth learning =] as crap as it is [as a programming language], its seamless integration with MSEXCEL and MSACCESS is so handy, and if you get the Enterprise package that exports .exe, it's the most handy thing to have around when you want to quickly knock up a useable application [with no fuss making the GUI... the other languages are PAINFUL when it comes to GUIs]
--- End quote ---
They seriously need to update the language, the syntax is still very much VB5 (VB, on the other hand, has advnaced 3 or 4 versions).
Also, object orientation would be nice...
I've heard of VSTA, but I'm not sure what the implication that has in terms of programming. If only I could then use C#...I would be in heaven (it's the least evil child of the .NET family :P)
Mao:
--- Quote from: Excalibur on August 16, 2008, 03:14:41 am ---
--- Quote from: Mao on August 15, 2008, 08:13:08 pm ---Visual Basics is worth learning =] as crap as it is [as a programming language], its seamless integration with MSEXCEL and MSACCESS is so handy, and if you get the Enterprise package that exports .exe, it's the most handy thing to have around when you want to quickly knock up a useable application [with no fuss making the GUI... the other languages are PAINFUL when it comes to GUIs]
--- End quote ---
They seriously need to update the language, the syntax is still very much VB5 (VB, on the other hand, has advnaced 3 or 4 versions).
Also, object orientation would be nice...
I've heard of VSTA, but I'm not sure what the implication that has in terms of programming. If only I could then use C#...I would be in heaven (it's the least evil child of the .NET family :P)
--- End quote ---
i reckon, haha
but then, i suppose its a compromise between power and efficiency. VBA imo is very light-weight. if they decide to upgrade it to VB.NET, i think it'll chew up a fair bit more system resources, considering that the MSOFFICE application is already running. In terms of productivity, i don't think that's a good sacrafice, since the scripts need not be so complicated in VBA. [with that said, automatic formatting would be nice... it's so confusing xD]
Mao:
--- Quote from: costargh on August 15, 2008, 11:06:45 pm ---does anyone have any spiffy little programs they have written or applications they have made etc that can be sent and opened on any normal comp?
Id liek to see the work u guys do in IT
--- End quote ---
here's something i knocked up to decipher this thread
nothing flash, if you aren't careful it'll throw errors at you
excal:
--- Quote from: Mao on August 16, 2008, 08:45:39 am ---
--- Quote from: Excalibur on August 16, 2008, 03:14:41 am ---
--- Quote from: Mao on August 15, 2008, 08:13:08 pm ---Visual Basics is worth learning =] as crap as it is [as a programming language], its seamless integration with MSEXCEL and MSACCESS is so handy, and if you get the Enterprise package that exports .exe, it's the most handy thing to have around when you want to quickly knock up a useable application [with no fuss making the GUI... the other languages are PAINFUL when it comes to GUIs]
--- End quote ---
They seriously need to update the language, the syntax is still very much VB5 (VB, on the other hand, has advnaced 3 or 4 versions).
Also, object orientation would be nice...
I've heard of VSTA, but I'm not sure what the implication that has in terms of programming. If only I could then use C#...I would be in heaven (it's the least evil child of the .NET family :P)
--- End quote ---
i reckon, haha
but then, i suppose its a compromise between power and efficiency. VBA imo is very light-weight. if they decide to upgrade it to VB.NET, i think it'll chew up a fair bit more system resources, considering that the MSOFFICE application is already running. In terms of productivity, i don't think that's a good sacrafice, since the scripts need not be so complicated in VBA. [with that said, automatic formatting would be nice... it's so confusing xD]
--- End quote ---
TBH, I spend more time trying to get to gripes with the quirks in VBA syntax that it wouldn't matter anyway.
VB.net is still fairly lightweight, and more people would know VB.net over VB5/VBA. I mean...there's worse out there *looks at Java*
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version