PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic

[Harlan Grove]

yeah.. but what are you gonig to do when you hit a measly 64k rows?

Since I limit myself to no more than 2000 rows in anything I design, doesn't
seem to be an issue.

i mean.. i poop in 1m row row incremenets

Someday you may grow up & stop taking so much pride in your excreting
functions. But if you have nothing else to be proud of . . .

what are you going to do when you need to SHARE this with another user?
email it to them?

Nope. Use batch files to copy files to other offices' file servers into
prespecified locations. Also distribute documentation the same way. Then
send e-mail about the distribution to file servers.

what are you going to do when you hit the 2gb limit IN EXCEL? (i've
breached it; have you?)

I'm not foolish enough to get close to it. If I need to work with that much
data I use other software. That's you're foolish enough to have come close
to this limit only provides further evidence (if such were needed) that
you're clueless.

 

[Harlan Grove]

do you really allow people to tell you what kinda perms you have on
your machine?

....

If it's not 'my' machine, i.e., I didn't buy it & I don't own it, yes, I do
let the owner (my employer) set my user permissions. They kinda have the
right to do so, no?

i walk into contracts; and people give me sa/local admin without even
thinking twice. (i think that it has to do with my billrate lol)

Must be small companies so desperate for help that they'd even hire you.

 

[Jay Petrulis]

hahah wow Jay i didnt know there were really living breathing thinking
excel dorks.

i'll make a better example tonight.

-aaron

Still waiting for the better example. Care to back up your claim with
a specific and testable solution?

As I mentioned, I do not require any comparison to an Excel solution.
Assume that I only have Access installed. Just get the job done in
Access, please. Not an outline, not unfinished ideas. Not code that
you still have to translate. A working solution. As you claim, you
can do this much easier using a database than any Excel dork can, so a
detailed post should not take long, either.

Please do not use Harlan's suggestion of setting a reference to the
Excel object model. That is not a pure Access solution.

 

[aaron.kempf]

Tony

if you could post on here without being a clueless MDB newbie; that
would help also

i dont need responses.

i need people to start speaking the TRUTH.

you guys slam DAP and ADP all day long. you slam VB.

if you dont want an argument; then you guys need to stop talking trash.

all im doing is giving you 10% of your own egocentricism back in your
face.

 

[JakeyC]

aaron -

Unlike Mr. Toews, I note that you are neither valuable, nor
professional.

If your use of spreadsheets involves re-creating them several times a
week or 'copying and pasting' 100 times over, perhaps you should get
back to basics.

Press 'F1' on your keyboard, and type the word 'macro' into the speech
bubble that the cute animated assistant offers.
You may well learn something.

 

[Oorang]

Wow man, don't be all mad at me cause your lack of people skills (which you
are showing right this second) is screwing up your life.

Besides you have no idea what I do for a living. But I'll give you a hint.
One of them is devolop databases. I just happen to feel excel is less labor
intensive for a lot of things. I mean why go to all the trouble to use a
database and set things up manually when it's frequently all prebuilt and at
your fingertips.

Remeber the idea is to get the job done in a reasonable amount of time. Not
prove how smart you are. Or do the "optimum" solution. More over you CAN
email out reports from excel automaticlly you are just ignorant as to how.
Finally even if you email your database reports out, how pray tell would you
make them interactive without emailing out the entire database or setting up
access to said. This get's even more complicated if you have personal
offsite.

 

[Oorang]

Gee I don't know about that Tony... This DOES seem to be the most active
thread in the group :-S

 

[Tony Toews]

Gee I don't know about that Tony... This DOES seem to be the most active
thread in the group :-S

<chuckle>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[aaron.kempf]

you're a dipshit; it's the wrong platform kids

spreadsheets; all spreadsheets-- involve cutting and pasting the same
formula 100 times.

-Aaron

 

[dbahooker]

EXCEL DOESNT HAVE REPORTS THAT WHY I HATE IT AND I THINK THAT ALL
SPREADSHEET DORKS SHOULD DIE A PAINFUL DEATH.

 

[dbahooker]

just for the record; no i dont get any specs; i deliver solutions

half of my work is fixing spreadsheet messes. the other half is fixing
MDB messes.

SQL Server is the answer to all your problems; you guys need to lose
the training wheels and start doing real dev.
i mean-- if you're going to write it; write it correctly the first time
instead of having a 2gb limit and crap performance

 

[Harlan Grove]

spreadsheets; all spreadsheets-- involve cutting and pasting the same
formula 100 times.

It's the spreadsheet equivalent of iteration.

What's the matter? Having some difficulty getting matrix inversion code
programmed in VBA?

 

[Jay Petrulis]

spreadsheets; all spreadsheets-- involve cutting and pasting the same
formula 100 times.

You are right -- that is all that can be done with a spreadsheet. Very
good, Aaron.

However, why are you still discussing spreadsheets at this point in the
thread? *You* were going to offer a solution to Harlan's matrix
challenge without using Excel. You would be able to show some
competency with databases, rather than just talk about how good you
are.

I, for one, am still waiting for your solution.

 

[Harlan Grove]

(e-mail address removed) wrote...

just for the record; no i dont get any specs; i deliver solutions

....

Oh, so you prey on small companies that don't really have a clear idea
why they've hired you.

How's the matrix inversion coding going?

 

[aaron.kempf]

Lonnie

**** yourself.

go and play with your spreadsheets, little script kiddie

i choose the best tools for the job
and i'd rather a cup of bloody boogers than use Excel in the real world
for anything.

you're the one-trick pony.. i mean.. what are you going to do; make a
spreadsheet of all the people that swear in a newsgroup and block me??

WHAT HAPPENS WHEN YOU HIT 64K ROWS, KID?

-Aaron

 

[aaron.kempf]

Jakey

if you really are stupid enough to think that i dont know what a macro
is-- i mean.. maybe you should just stop posting on usenet.
i mean-- come on; i've written hundreds and thousands of pages of vba
in excel and probably 10,000 pages of vba code for access.

i know vba like the back of my hand.

i use one consistent language across outlook; word; excel and access; i
use one language for ASP and for DTS and SQL jobs.

what does harlan do?

HE MAKES THE SAME FRIGGIN SPREADSHEET WEEK IN AND WEEK OUT.
IT'S IMPOSSIBLE to automate excel and make it half as efficient as
Access.

MSDE is a free engine; you guys should be using MSDE for everything you
do instead of excel
i mean.. ACCESS DATA PROJECTs rock

and mdb and spreadsheets are for babies.

LITTLE GIRLIE-MEN use excel

 

[Harlan Grove]

(e-mail address removed) wrote...

i know vba like the back of my hand.

....

But you never post any VBA code to newsgroups to show off your
*claimed* but unsubstantiated VBA coding brilliance.

Google Groups search on newsgroup * from author aaron.kempf containing
the phrase 'End Function' - none of the 3 threads found showed any VBA
code from you. Switching to the phrase 'End Sub' showed 1 of 3 matching
threads with this contribution from you.

Public Sub CaptureExcelValues()

Dim xlApp
Dim wb
Dim ws
set xlApp = createobject("EXCEL.APPLICATION")
set wb = xlApp.workbooks.open("c:\myspreadsheet.xls")
set ws = wb.sheets("MyHappySheetName")

then you can just do anything that you want with it.

End Sub

Hardly original, hardly complicated. And you never followed up with the
OP when it was clear your response didn't get the OP anywhere close to
what s/he needed.

http://groups.google.com/group/micr..._frm/thread/a1deecf281271807/f1a7d053582ad88e

(or http://makeashorterlink.com/?M5BA2382C ).

what does harlan do?

HE MAKES THE SAME FRIGGIN SPREADSHEET WEEK IN AND WEEK OUT.
IT'S IMPOSSIBLE to automate excel and make it half as efficient as
Access.

....

This is your constant claim. Because *YOU* know nothing more than
recreating spreadsheets day after day (someday you may get one right,
accidents can happen), you claim that's what *I* do. You have no clue
what I do.

LITTLE GIRLIE-MEN use excel

I'll leave it up to others to figure out what to call people like you
who claim database expertise and the ability to do ANYTHING Excel can
do in either VBA or Access or SQL Server but just can't seem to figure
out how to prove it. Loudmouth, ignoramus and bullshitter aren't
inappropriate, but they're inadequate to sum up the full extent of your
militant ignorance.

 

[Harlan Grove]

(e-mail address removed) wrote...
....

you're the one-trick pony.. i mean.. what are you going to do; make a
spreadsheet of all the people that swear in a newsgroup and block me??

....

No one in their right mind would dream of blocking you. No matter how
ignorant and misanthropic the rest of us may be, we can read your posts
and realize we've still a long ways to go before we'd reach your level.
It's a testament to your, er, character that there's no limit to how
low you'll go. Keep on impressing the rest of us!

 

[aaron.kempf]

hahaha good stuff harlan

so you measure my brilliance based on how many threads i have with end
function, huh?

END FUNCTION

i'll end your function spreadsheet dork

 

[Harlan Grove]

(e-mail address removed) wrote...

hahaha good stuff harlan

so you measure my brilliance based on how many threads i have with end
function, huh?

....

Actually, I measure your credibility by the quantity of VB[|A|S] code
you've posted. Minimal code, so minimal credibility.

Do you know how to do anything other than rant?

BTW, how's the matrix inversion coding going? Need some help?