LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 80
Default How do you program Excel to import/export data to XML files

I am looking for some guidance, pointers and examples to do the following in
Excel 2003 (or later).
Given a workbook with 3 worksheets with each worksheet containing unique
tables, I would like to add toolbar menu options such that the user is able
to:
1. Export every table to one single XML file
2. Export a single table to an XML file
3. Import XML files into the workbook overriding all exiting data
4. Import XML files into the workbook appending the existing data
This file will be a template file where users can save and share data
through the XML files.
Any help is appreciated. Ive found some XML information but not to the
level I need to achieve.

TIA
- Pat

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
export data between excel files scott Excel Discussion (Misc queries) 1 May 28th 10 09:28 PM
Import/export netCDF files to Excel Piet Jongejan Excel Discussion (Misc queries) 1 July 22nd 08 12:32 PM
Export data from SQL into Excel files Kim[_3_] Excel Discussion (Misc queries) 2 October 31st 07 07:24 AM
export/import excel data to word doc. properties William Excel Programming 0 September 21st 04 08:41 PM
Question of Import Export Files unplugs[_12_] Excel Programming 6 June 21st 04 02:47 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"