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