ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get the data/xml/export option (https://www.excelbanter.com/excel-discussion-misc-queries/39814-how-do-i-get-data-xml-export-option.html)

Nick

How do I get the data/xml/export option
 
My export option is disabled under data/xml tab. What is the exact feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?

thanks
Nick

Peo Sjoblom

One way would be to do a web query, first preformat the cells as text, then
do the query (dataimport external datanew web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import

--
Regards,

Peo Sjoblom

(No private emails please)


"Nick" wrote in message
...
My export option is disabled under data/xml tab. What is the exact
feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?

thanks
Nick



Nick

But is their a way to enable the export selection on the data / xml menu?

nick

"Peo Sjoblom" wrote:

One way would be to do a web query, first preformat the cells as text, then
do the query (dataimport external datanew web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import

--
Regards,

Peo Sjoblom

(No private emails please)


"Nick" wrote in message
...
My export option is disabled under data/xml tab. What is the exact
feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?

thanks
Nick





All times are GMT +1. The time now is 03:39 PM.

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