S
Shane
Hi.
I have an excel workbook that stores data relating to a client
project. My task is to incorporate the figures and charts from a
spreadsheet into the submission.
The problem I'm having is that the excel cell data isn't coming across
in the format I'd like i.e. $5,000,000 comes over as 5000000. Fair
enough. My research tells me there's three ways to overcome this.
1. DDE - Possible but I'd want call DDE in VBA then put the data into
bookmarks.
2. Reformat the excel cells as text - Confuses the operator and messes
with calculations.
3. Mergefields with switches - I'd rather DDE to be honest. My
feeling is that mergefields add a level of complexity that I could
avoid. I could be wrong.
A forth is to store the cell data in an .ini file then read this into
the Word template reformatting with VBA. The charts are easy.
My question is about any alternate methods to achieve the result or
have I coverd some decent options and just need to work out what I
want to do.
Thanks in advance.
Shane
I have an excel workbook that stores data relating to a client
project. My task is to incorporate the figures and charts from a
spreadsheet into the submission.
The problem I'm having is that the excel cell data isn't coming across
in the format I'd like i.e. $5,000,000 comes over as 5000000. Fair
enough. My research tells me there's three ways to overcome this.
1. DDE - Possible but I'd want call DDE in VBA then put the data into
bookmarks.
2. Reformat the excel cells as text - Confuses the operator and messes
with calculations.
3. Mergefields with switches - I'd rather DDE to be honest. My
feeling is that mergefields add a level of complexity that I could
avoid. I could be wrong.
A forth is to store the cell data in an .ini file then read this into
the Word template reformatting with VBA. The charts are easy.
My question is about any alternate methods to achieve the result or
have I coverd some decent options and just need to work out what I
want to do.
Thanks in advance.
Shane