Re: Renaming files & importing them

Tech-Archive recommends: Fix windows errors by optimizing your registry

Is this really a VB question, or were you talking about using Excel or
something similar to do this? Unless you're using VB6 or before, this is
not the appropriate group for your question.



Rob

<deepaj87@xxxxxxxxxxx> wrote in message
news:1183045486.214870.167660@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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 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)
  • 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)
  • Renaming files & importing them
    ... is there a macro to go through many subfolders and change the ... if they're all in groups separated by folders? ... I have a series of groups of XML files, all following the same XML Map ...
    (microsoft.public.vb.general.discussion)
  • importing XML files
    ... is there a macro to go through many subfolders and change the ... they're all in groups separated by folders? ... I have a series of groups of XML files, all following the same XML Map ...
    (microsoft.public.excel.programming)
  • Re: VBA: For Count, when count changes from cell to cell
    ... with Excel 2000. ... reporting Macro being unavailable. ... Sub CalculateI3() ... means that you can refer to it in a cell just like a built-in Excel function. ...
    (microsoft.public.excel.misc)