C
Colleyville Alan
I am working on an automation project to create a report showing mutual fund
performance data. Currently, the info is in a large spreadsheet and the
users find the fund and copy it to a formatted template.Then the final
formatted version is copy/pasted into PowerPoint as an enhanced metafile
image since the spreadsheet is too large (22 columns) to embed in PPT. I
started out desinging the automation project with Access, Excel, and
PowerPoint object models interfacing with each other. I have designed an
Access database in which the user will choose a company's 401k plan from a
list box, then the database runs an SQL query and outputs the info to an
ActiveX spreadsheet embedded in the main form. This is much faster and has
less memory problems than working with Excel did.
From here, using VBA, I will copy a range of cells, open PowerPoint and
paste the information as the emf image mentione earlier. The embedded
spreadsheet is a must as the users are used to working with spreadsheets and
seeing the data in a certain format.
Here's the problem. My copy of Access came with some ActiveX components. I
have tried the MS Office Spreadsheet (Web Components) and there does not
appear to be a wordwrap function. I also tried the ActiveX from Formula
One. I got all of information to write to the correct cells and got the
formatting right - the whole thing looked fine. Then I found out that the
Formula One clipboard supported copying with formatting but only within the
Formula One environment. For external copying (i.e. my idea to copy the
info to PPT), it only supports the Windows clipboard and would lose all
formatting.
What I need: I need an ActiveX spreadsheet component that I can embed into
an Access form. No data-linking is needed, the query results are read into
an array and written out. In fact, I do not need any calculation functions,
not even SUM, since the data will not be manipulated in any way, it will
only be formatted. All I need is a component that has basic formatting
(Bold, borders, number formats, color filling, aligning, and wordwrap) and
the ability to copy that formatting such that when I go to use the
PasteSpecial function in PPT, I have the "Enhanced Metafile Format" as an
option. I only need the control to go to 22 columns wide and at the very
most, 200 rows so even a crippleware solution might work (though I tired Bee
Grid and found the trialware to only have 10 columns!).
A more minor desire would be to have the ability to embed a checkbox or
something similar at the front of each row so that the user can select it to
see if alternative funds are available should an existing fund choice be
found to be performing badly. I could use the checked items to run a query
and refresh the output, or if not a checkbox, a treeview with the
alternative funds hidden.
Does anybody have a favorite ActiveX spreadsheet that does these few things?
Thanks
Alan
performance data. Currently, the info is in a large spreadsheet and the
users find the fund and copy it to a formatted template.Then the final
formatted version is copy/pasted into PowerPoint as an enhanced metafile
image since the spreadsheet is too large (22 columns) to embed in PPT. I
started out desinging the automation project with Access, Excel, and
PowerPoint object models interfacing with each other. I have designed an
Access database in which the user will choose a company's 401k plan from a
list box, then the database runs an SQL query and outputs the info to an
ActiveX spreadsheet embedded in the main form. This is much faster and has
less memory problems than working with Excel did.
From here, using VBA, I will copy a range of cells, open PowerPoint and
paste the information as the emf image mentione earlier. The embedded
spreadsheet is a must as the users are used to working with spreadsheets and
seeing the data in a certain format.
Here's the problem. My copy of Access came with some ActiveX components. I
have tried the MS Office Spreadsheet (Web Components) and there does not
appear to be a wordwrap function. I also tried the ActiveX from Formula
One. I got all of information to write to the correct cells and got the
formatting right - the whole thing looked fine. Then I found out that the
Formula One clipboard supported copying with formatting but only within the
Formula One environment. For external copying (i.e. my idea to copy the
info to PPT), it only supports the Windows clipboard and would lose all
formatting.
What I need: I need an ActiveX spreadsheet component that I can embed into
an Access form. No data-linking is needed, the query results are read into
an array and written out. In fact, I do not need any calculation functions,
not even SUM, since the data will not be manipulated in any way, it will
only be formatted. All I need is a component that has basic formatting
(Bold, borders, number formats, color filling, aligning, and wordwrap) and
the ability to copy that formatting such that when I go to use the
PasteSpecial function in PPT, I have the "Enhanced Metafile Format" as an
option. I only need the control to go to 22 columns wide and at the very
most, 200 rows so even a crippleware solution might work (though I tired Bee
Grid and found the trialware to only have 10 columns!).
A more minor desire would be to have the ability to embed a checkbox or
something similar at the front of each row so that the user can select it to
see if alternative funds are available should an existing fund choice be
found to be performing badly. I could use the checked items to run a query
and refresh the output, or if not a checkbox, a treeview with the
alternative funds hidden.
Does anybody have a favorite ActiveX spreadsheet that does these few things?
Thanks
Alan