I am trying to export selected items from a report to an txt file (ultimately txt will be xml).The txt files need to go to specific directories and they should be named based on one of the field values.For example I have these products:\[quote\] --NAME--|-- SKU -- |--COLOR ---|
--prodA--|-- BL1-- |--blue---|
--prodB--|-- RD1-- |--red---|
\[/quote\]I need to export that data to these files:\[quote\] \directoryA\prodB.xml
\directoryB\prodB.xml\[/quote\]How do I do this with VBA?
--prodA--|-- BL1-- |--blue---|
--prodB--|-- RD1-- |--red---|
\[/quote\]I need to export that data to these files:\[quote\] \directoryA\prodB.xml
\directoryB\prodB.xml\[/quote\]How do I do this with VBA?