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
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..
