VBA to read a file

I am looking for someone, familiar with VBA to develop a code to read a standard format of weather files (which are comma delimiter files) and display data in an excel sheet in a clear format.