Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Export to XML from different worksheets (to different files)

I think I''m losing my mind, I've been looking everywhere but I cannot
seem to find a macro to do the following:
* I need the ability to export multiple XML files from a single Excel
document.
* Ideally I will have worksheet and every column would export to a
separate XML file (column A would be the "tag name" for all XMLs). If
this is not possible, then I would be open to have separate worksheets
instead of separate columns
* I would like to name each XML based on the top row (B1, C1, etc).

Is there a macro that can do this? I havent been able to find a macro
that takes care of all the needs above.

Help!!!!!
Reply
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 from SQL into Excel files Kim[_3_] Excel Discussion (Misc queries) 2 October 31st 07 07:24 AM
There's no export to dbf files from XL2007? Kluster Excel Discussion (Misc queries) 11 April 11th 07 03:48 AM
How do I export files to microsoft money ? Cobie Excel Worksheet Functions 0 January 8th 07 12:19 PM
how to export worksheets into seperate files PeterRad Excel Discussion (Misc queries) 2 August 9th 06 04:10 AM
export gif file files k2sarah Charts and Charting in Excel 1 December 5th 05 04:43 PM


All times are GMT +1. The time now is 07:35 PM.

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"