I have a linux shell script that outputs data to a text file.
I can name that file anything, xxx.csv or xxx.txt
I can delimit with tabs or commas, whatever necessary.
I then ftp the file to a windows box where I have MS Excel 2007.

I want to have a sort of dynamic spreadsheet that depends on the data
in that file. That file will always exist on the PC in the same static
path.

The file gets updated daily. The data for some cells could change or
there could be new rows. (Not new columns - new columns would mean I
would have to add a column to my spreadsheet).

So I want to create a spreadsheet that has all the colum headers, all
the column and row spacing, colors, fonts etc. Then I want to import
the new data daily (or actually when I open the sheet) and overwrite
the existing data. This could be a macro (I guess it has to be a
macro). Maybe something that would launch on open, or even if I just
added a macro button to the sheet it would be fine.

So the data would start say in cell A4. There are 10 columns, so it
would stretch to J4
and there could be 300 rows one day, 302 the next and even 298 the
next day.
I want to make sure the old data is gone and only the new data
displays.


Thanks