02-25-2013, 04:02 PM
Hi!
I hope there is someone who can help...
I am using a windows app that carries out energy calculations (Be10.exe) based on data in an xml-file. I am using windows XP. I have about 1000 xml files generated parametrically. I want to carry out sequential calaculations, one at a time, by reading in the xml-files into the app and then generating (by pressing on 2 buttons) two extra xml-files which contain the results of the calculation. The two generated files are automatically saved into the same folder as the parent xml-file.
The sequence is:
1 Look in file to see how many parent xml-files.
2 Open first file xl-file in Be10.exe.
3 Generate the two result xml-files.
4 Shut the open xml-files.
5 Move onto the next parent xml-file and start at number 1 again.
6 Continue until all parent files are calculated.
I just cannot see how to produce this macro - can anybody help?!
I hope there is someone who can help...
I am using a windows app that carries out energy calculations (Be10.exe) based on data in an xml-file. I am using windows XP. I have about 1000 xml files generated parametrically. I want to carry out sequential calaculations, one at a time, by reading in the xml-files into the app and then generating (by pressing on 2 buttons) two extra xml-files which contain the results of the calculation. The two generated files are automatically saved into the same folder as the parent xml-file.
The sequence is:
1 Look in file to see how many parent xml-files.
2 Open first file xl-file in Be10.exe.
3 Generate the two result xml-files.
4 Shut the open xml-files.
5 Move onto the next parent xml-file and start at number 1 again.
6 Continue until all parent files are calculated.
I just cannot see how to produce this macro - can anybody help?!