Renaming files & importing them

Hi!

Firstly, is there a macro to go through many subfolders and change the
extension of all the files?

And then Is there a way to somehow get 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 using
another macro, 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.

.

Relevant Pages

  • changing file extension & importing
    ... So, have the macro get ... 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.basic.visual.misc)
  • 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)