Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execl 2003 XML Question
Would someone tell me how I can get my Excel XML data which is in spreadsheet format into a Row Format? I'd like to use Excel to construct data in XML and use Word as one of the reporting mechanisms in its table row format
thx Ted |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execl 2003 XML Question
A very convenient, albeit ugly, way of getting Excel tabular data into Word is as follows
Insert a field in WORD (Control + F9) : you can't just type the {} Within the {} type DDEAUTO Excel "MyWKB.XLS" NamedRange i.e. { DDEAUTO Excel "MyWKB.XLS" NamedRange Where "MYWKN.XLS" is the fully qualified name of the workbook; duplicate \ if this is included in this specification, and NamedRange is a named area of the workbook Note 1. there are no commas between the argument 2. Excel will start and open the workbook whenever the data is refreshed (this is the ugly bit, because Excel must be closed manually 3. the data in Word can be refreshed, unlike Copy + Past |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execl 2003 XML Question
Thank you for the response. I get an error message "Word cannot obtain Data from Exel for Data.xls, NAMEDRANGE. i am not sure why this error displaying
Te ----- AA2e72E wrote: ---- A very convenient, albeit ugly, way of getting Excel tabular data into Word is as follows Insert a field in WORD (Control + F9) : you can't just type the {} Within the {} type DDEAUTO Excel "MyWKB.XLS" NamedRange i.e. { DDEAUTO Excel "MyWKB.XLS" NamedRange Where "MYWKN.XLS" is the fully qualified name of the workbook; duplicate \ if this is included in this specification, and NamedRange is a named area of the workbook Note 1. there are no commas between the argument 2. Excel will start and open the workbook whenever the data is refreshed (this is the ugly bit, because Excel must be closed manually 3. the data in Word can be refreshed, unlike Copy + Past |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question for MVP - install Excel 2003 on MS Server 2003 | Setting up and Configuration of Excel | |||
How do I synchronize execl with pocket pc? | Excel Discussion (Misc queries) | |||
Execl print to fit paper | New Users to Excel | |||
EXECL | Setting up and Configuration of Excel | |||
Need help with two Execl VBA problems | Excel Programming |