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/micro...a7d053582ad88e

(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 bull****ter aren't
inappropriate, but they're inadequate to sum up the full extent of your
militant ignorance.