changing file extension & importing

Hi!

Firstly, is there a program I can write to go through many subfolders
and change the extension of all the files? Or if I do that myself,
Is there a way to somehow write a macro to seek the XML files, if
they're all in groups separated by folders? So, have the macro get
the 1st file (using an XML map), edit it (by performing macros I've
already written in Excel), save and close, then go get the next
folder?

I have a series of groups of XML files, all following the same XML Map
in Excel, and I want a macro to bring them in, group by group, saving
them as separate files.

Thanks!

.

Relevant Pages

  • Changing file Xtensions & importing
    ... the 1st file, edit it (by performing macros I've ... I have a series of groups of XML files, all following the same XML Map ... in Excel, and I want a macro to bring them in, group by group, saving ...
    (comp.lang.java.programmer)
  • Re: Renaming files & importing them
    ... is there a macro to go through many subfolders and change the ... I have a series of groups of XML files, all following the same XML Map ... in Excel, and I want a macro to bring them in, group by group, saving ...
    (microsoft.public.vb.general.discussion)
  • Re: PowerPoint to XML
    ... and want to write macro for converting ppt files to ... XML file (in DTD format). ... programs will save to a series of XML files as the native format. ...
    (microsoft.public.powerpoint)
  • Export to XML from different worksheets (to different files)
    ... I need the ability to export multiple XML files from a single Excel ... separate XML file. ... then I would be open to have separate worksheets ... Is there a macro that can do this? ...
    (microsoft.public.excel.worksheet.functions)
  • Macro to save an xml (Excel2007) file into an Excel97 format
    ... (in fact I have a DOS script that selects all .xml files in a certain ... excel will execute the macro right away when started. ... Function FileNameNoExt(strPath As String) As String ... Dim NewFName As String ...
    (microsoft.public.outlook.mac)