ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How Do I specify where XML data gets imported into Excel (https://www.excelbanter.com/excel-discussion-misc-queries/24173-how-do-i-specify-where-xml-data-gets-imported-into-excel.html)

Diane

How Do I specify where XML data gets imported into Excel
 
I have XML data that I would like to import up as fllows in a spreasheet:

Cell A2: Job Number
Cell A3: Customer Number

A4 through A29 should recive the <AMOUNT data
B4 through B29 should receive the <QUANTITY data

etc etc

Sometimes all the fields will be filled, sometimes not. Any help would be
greatly appreciated.

Regards,
Diane

Starwing

Hi Diane!

You should see ther microsoft.public.xml

Starwing




All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com