| reply to yock
Re: [OT] excel help not to sound dumb, but what is VBA? |
|
 yockTFTCPremium
join:2000-11-21
Miamisburg, OH
kudos:3 | Visual Basic for Applications
It's a quasi-object-oriented macro language for automating complex tasks in Microsoft Office applications.
--
Have more fun with your GPS.
Geocaching.com |
|
 drewAutomaticPremium
join:2002-07-10
Port Orchard, WA
kudos:6
 ·wavebroadband
| reply to Dezbend
Visual Basic for Applications.
Essentially, it's the programming language that allows you to do all sorts of complicated stuff in Office products without being a full-fledged developer.
While I cannot guarantee any results, if you'd be willing to share with me a copy of the XLS you have and maybe a bit more detail on the spec, I could *possibly* write the app. yock  knows far more VBA than I do IIRC, but I know his time is more valuable than mine.
--
Come play Mafia! | My Picture Blog |
|
 brianPremium
join:2002-05-02
Lake Forest, CA | I know more VBA than I want to admit. (I hate MS Access!) |
|
yockTFTCPremium
join:2000-11-21
Miamisburg, OH
kudos:3 | My hatred of Access is only surpassed by that of VBA. |
|
drewAutomaticPremium
join:2002-07-10
Port Orchard, WA
kudos:6 | reply to brian
MS Access is a pile of garbage. GARBAGE. |
|
yockTFTCPremium
join:2000-11-21
Miamisburg, OH
kudos:3 | reply to yock
Except, I should add, I'm happy to help with either. =) |
|
drewAutomaticPremium
join:2002-07-10
Port Orchard, WA
kudos:6 | reply to yock
RE: VBA
While VBA is a bastard-child of stuff that should've never been born, it's pretty freaking handy IMO. |
|
yockTFTCPremium
join:2000-11-21
Miamisburg, OH
kudos:3 | reply to drew
said by drew:MS Access is a pile of garbage. GARBAGE. Except that as a relational database engine it's designed to do the things Dez is talking about. Creating complex copy routines in VBA for Excel is essentially recreating the relational links designed into any RDBMS. Access may be a bad RDBMS, but it still is one.
--
Have more fun with your GPS.
Geocaching.com |
|
|
|
drewAutomaticPremium
join:2002-07-10
Port Orchard, WA
kudos:6 Reviews:
·wavebroadband
| I didn't say it didn't serve a purpose, I'm just saying it's garbage.
I do a bit of "side" work for my CEO at one of his buddy's businesses. They have an application that stores all of their auto body work, etc. and it's entirely in Access. There are THREE people accessing the same DB in access.. the thing is so slow.... Incredible.
I don't even want to know how much better it would run if PostgreSQL was made to be the backend... their licensing is free even to commercial products.
--
Come play Mafia! | My Picture Blog |
|
