Hello: I have a currently existing Excel 2007 sheet that I can do a (In Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt which is a test file in the format of: Temp Hi Low Out Wind Wind Hi Hi Wind Heat THSW Rain Solar Solar Hi Solar UV Hi Heat Cool In In In In In In Air Soil 1 Soil Leaf Wind Wind ISS Arc. Date Time Out Temp Temp Hum Dew Speed Dir Run Speed Dir Chill Index THW Index Bar Rain Rate Rad. Energy Rad. UV Dose UV D-D D-D Temp Hum Dew Heat EMC Density ET Moist. Temp 1 Wet 1 Samp Tx Recept Int. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 7/22/11 0:01 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 1.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 46 56.9 79.3 8.46 .0722 0.000 153 69.0 15 9 1 39.1 1 7/22/11 0:02 75.6 75.6 75.6 69 64.7 2.0 WNW 0.03 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 47 57.5 79.3 8.66 .0722 0.000 153 69.0 15 20 1 87.0 1 7/22/11 0:03 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 2.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 47 57.5 79.3 8.66 .0722 0.000 153 69.0 15 22 1 95.7 1 7/22/11 0:04 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 48 58.1 79.4 8.86 .0721 0.000 153 69.0 15 21 1 91.3 1 7/22/11 0:05 75.6 75.6 75.6 69 64.7 1.0 WNW 0.02 3.0 WNW 75.6 77.3 77.3 75.1 1009.5 0.00 0.00 0 0.00 0 0.0 0.00 0.0 0.000 0.007 79.5 48 58.1 79.4 8.86 .0721 0.000 153 69.0 15 21 1 91.3 1 and is properly formatted automatically by a Text-To Colums setup already in the MS Excel sheet so all I need to do each day is Refresh All and select the filename and it pulls in the data in the proper column. For the life of me I cannot see how to do this in Calc...and opening the existing sheet gets the right format, but I'm at a loss of how to get new data into it without redoing the whole text to columns every time (not an option due to time constraints here each day when this has to happen...data is available at 59 past the hour and needs to jut come in to be used by 15 past the next hour. Can anyone help with this? As of right now its the one thing keeping me from dumping the Office 2007 suite. -- ===[George R. Kasica]=== +1 262 677 0766 President +1 206 374 6482 FAX Netwrx Consulting Inc. Jackson, WI USA http://www.netwrx1.com georgek@netwrx1.com ICQ #12862186 -- Unsubscribe instructions: E-mail to users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted