P
(PeteCresswell)
User has a spreadsheet: one tab for each "Fund".
They also have a little MS Access DB with comments for each fund.
A given fund has many comments: one for each Begin/End date
range.
At "Open" time, the spreadsheet needs to have the comments for
each fund/tab replaced with the latest-and-greatest comment from
the MS Access DB.
Questions (assuming that I'm going to write some DAO VBA in the
spreadsheet that fires at "Open" time, extracts the latest
comment for each fund, and pushes it into that fund's tab)
------------------------------------------------------------------------
- What would the most appropriate object to receive the comments
(which can be up to several pages of form text)? On the
sample sheet, the user has comments in a "Text Box" on one tab
and a monster cell on other tabs. Is one or the other
preferable? Is there a third alternative that trumps the
first two?
- What event am I looking for to fire when the user opens the
.XLS?
- Is my VBA code solution the logical one? Or does Excel offer
something more concise/user-modifiable? I'm thinking a
DAO.RecordSet populated by a query that groups by FundName and
does a Max on BeginDate.
They also have a little MS Access DB with comments for each fund.
A given fund has many comments: one for each Begin/End date
range.
At "Open" time, the spreadsheet needs to have the comments for
each fund/tab replaced with the latest-and-greatest comment from
the MS Access DB.
Questions (assuming that I'm going to write some DAO VBA in the
spreadsheet that fires at "Open" time, extracts the latest
comment for each fund, and pushes it into that fund's tab)
------------------------------------------------------------------------
- What would the most appropriate object to receive the comments
(which can be up to several pages of form text)? On the
sample sheet, the user has comments in a "Text Box" on one tab
and a monster cell on other tabs. Is one or the other
preferable? Is there a third alternative that trumps the
first two?
- What event am I looking for to fire when the user opens the
.XLS?
- Is my VBA code solution the logical one? Or does Excel offer
something more concise/user-modifiable? I'm thinking a
DAO.RecordSet populated by a query that groups by FundName and
does a Max on BeginDate.