Changing file Xtensions & 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 program to seek the XML files, if
they're all in groups separated by folders? So, have the program 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. I can't seem to figure it out in VB, so maybe
Java will work?

Thanks!

.

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: Creating XML file for Excel
    ... Can anyone direct me to a source of clear, concise information on how to build an XML file that can be opened by Excel as a spreadsheet? ... I need to build the file with the appropriate formatting requirements for the data, presentation aspects of the spreadsheet, and hopefully a way to make the data read-only. ... Playing around with XML import features in Excel and trying to make sense of an Excel spreadsheet saved as XML just gave me headaches ... ... The idea is for the user to just open these XML files in Excel and get a useable spreadsheet without spending a lot of time reformatting everything. ...
    (microsoft.public.excel)
  • Re: Creating Excel file from other program
    ... This time I need to create a simple Excel file that contains two or more ... This seems to be all that's needed from the opening Workbook tag Excel ... itself generates when saving workbooks as XML files. ...
    (microsoft.public.excel)
  • Creating XML file for Excel
    ... Can anyone direct me to a source of clear, concise information on how to ... build an XML file that can be opened by Excel as a spreadsheet? ... reports as XML files, almost all of them destined for Excel. ...
    (microsoft.public.excel)