Opening TXT files from a list Fixed width into Excel and editting them

Hi
I have been trying to resolve this for a while now.

I have a spreadsheet with a file path (cell B15) always fixed and a list of text files I need to open in column G (just 7 in the list). The plan is that it opens each individual txt file to the width dimensions specified and then save them with another name. The saving part I can do.

I am struggling with the loop to open the text file.

I have written the following code:

Please Login or Register  to view this content.

Any help would be greatly appreciated.
Thanks in advance.

The OpenText method does not return a workbook object, so you need to open the file first and set the object later - and make sure that you have a trailing \ in cell B15 for the path.

But you really don't need to use an array of workbooks unless you plan on doing something other than saving them.

Please Login or Register  to view this content.

Please use code tags when posting code.

Please Login or Register  to view this content.