----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, March 10, 2010 9:44 AM
Subject: [RBASE-L] - Re: Reports to Excel
You know what, I worked with Scott Salsbury on this once... I remember
writing VB code to connect to the RBase database and produce a srpeadsheet
In one of my Word apps, I connect to RBase for an envelope addressing
program.
I am going to email you the VBA code to connect to an RBase db, set a
recordset, etc. You can glean from that enough to get you started.
When you are in the VBA editor in Excel, find the Object Viewer. It will
list all the properties and methods of the Spreadsheet which will give you
clues about how to go about manipulating your data.
This incident is another reason I have encouraged people to grasp at least
VBScript as a useful tool as it is basically a subset of VB5/VB6 from which
VBA is based. Almost all of the language constructs are interchangable.
In our (I mean the developer community at large) there are few times that
the data doesn't become entwined with Microsoft Office products at some
point, so the above advice will likely hold true for some time. I know MS
has experimented with using Dot Net as the basis for Office products, but to
date it has failed miserably due to its' cumbersome size which translates to
snail pace performance.
file, including font attributes, blank lines, etc... The client actually
had this
running in production (it was his client, so I'm not sure I even have the
code
here anymore). Once you had an example piece of code to work with, it
was
easy to modify for your particular app. Even if I decide not to go that
way, it's
probably worth it to see if I have the code around here still...
Karen
Karen,
I don't fiddle with Excel much, but I have mucked around a bit with the
VBA in a few of the Office products. I am not certain that simple Macros
the IT guy has formulated are sophisticated enough to detect and
propogate
the slight variances in each dataset as it relates to factor number, but
I
am certain that VBA can do it, even though I haven't done it. This is
what
the Visual Basic for Applications language is used for in the Office
apps.
You have some Visual Basic background and it shouldn't be much of a
stretch for you to look at the Object Model of the Spread Sheet and do
it.
Get Crackin..
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
