How to: Open file, format data, save file, close file and repeat.

Hello everyone,

I have been given a university project where I need to do a lot of simulations.
After running these simulations, the outputs I receive are in the form of a text file with the extension ".OUT".
These outputs are in separate folders, in sets of 20, i.e."...\Set_1\data.OUT", "...\Set_2\data.OUT", "...\Set_3\data.OUT" through to "...\Set_20\data.OUT".

What I would like to do is:
1) Open the "data.OUT" text file in the folder "Set_1".
2) Use the Text to Columns feature of Excel to format a section of the text file into cells.
3) Save the workbook as "data.xlsx" in the same folder "Set_1".
4) Close the workbook.
5) Repeat steps 1 to 4 for the folders "Set_2", "Set_3", ..., "Set_20".

I have written some code as follows, but I keep receiving errors regarding the "Format" part of the code

Could someone please assist me?
Thanks in advance!

Please Login or Register  to view this content.

Can you post an example .OUT file?

Several problems here

Please Login or Register  to view this content.

is needed because excelapp is an object.

As you are opening an new instance of Excel, you need to qualify the objects to reference the new instance - otherwise they point at the the objects in the workbook containing the code..

Please Login or Register  to view this content.

Please Login or Register  to view this content.