Open File And Manipulate

[ajocius]

I have Excel 2010 on a Windows 8.1 machine. Attached are two files. The first is a sample data file with an extension of .csv. The second file is my attempt to open the file > Save it as an .xlsx file and start changing the worksheet. The .csv file is a log file I download from one of our test systems. These .csv files can have thousands of rows. I would like to delete all instances of <> and all the contents between <>. Lastly delete all the blank/empty columns. I think I got the 80% solution but am having difficulty with the rest. Request one of you smart VBA guys help an old test engineer out. Thanks.

Tony

[HaHoBe]

Hi, Tony,

have two or three macros or just one?

Please test (you might need to change the SaveAs part which will cause run-time errors withthe given anme and substitute ( and ) in the name respectively):

Please Login or Register  to view this content.

Since a csv will only have one worksheet as default I didnīt care for placing a sheet name in this code.

Ciao,
Holger