yock
TFTC
Premium
join:2000-11-21
Fairfield, OH | reply to drew
Re: [OT] excel help
If this requires a loop, then forget formulas. You really need VBA for that. |
|
Dezbend
Premium,MVM
join:2001-04-20 | not to sound dumb, but what is VBA? |
|
yock
TFTC
Premium
join:2000-11-21
Fairfield, OH
| 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 |
|
drew
Reformation
Premium
join:2002-07-10
Port Orchard, WA
clubs:
 ·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 |
|
bjl
Premium
join:2002-05-02
Newport Beach, CA | I know more VBA than I want to admit. (I hate MS Access!) |
|
yock
TFTC
Premium
join:2000-11-21
Fairfield, OH | My hatred of Access is only surpassed by that of VBA. |
|
drew
Reformation
Premium
join:2002-07-10
Port Orchard, WA
clubs: | reply to bjl
MS Access is a pile of garbage. GARBAGE. |
|
yock
TFTC
Premium
join:2000-11-21
Fairfield, OH | reply to yock
Except, I should add, I'm happy to help with either. =) |
|
drew
Reformation
Premium
join:2002-07-10
Port Orchard, WA
clubs: | 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. |
|
yock
TFTC
Premium
join:2000-11-21
Fairfield, OH
| 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 |
|
drew
Reformation
Premium
join:2002-07-10
Port Orchard, WA
clubs:
·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 |
|
