Hi :)
I had a go at using Fixed width but then needed to define each width in the
little box at the bottom which was uncomfortably small on my screen at my
resolution. Later on i tried it again and it had remembered the widths i had
defined last time. Sadly i could not find the fixed width
At 07:48 23/07/2011 -0500, George R. Kasica wrote:
I have a currently existing Excel 2007 sheet that I can do a (In
Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt ...
So that's a file available to your system?
Yes, its a flat file created from some weather equipment.
... which
Hi :)
I think i would approach this by using a database program rather than importing
into a spreadsheet program. A database program such as Base should be able to
read the text-files directly. Queries, Forms and Reports can be set-up to do
the required calculations.
Setting it up would
Hi :)
I think i would approach this by using a database program rather than
importing
into a spreadsheet program. A database program such as Base should be able to
read the text-files directly. Queries, Forms and Reports can be set-up to do
the required calculations.
Interesting idea, and
Le 25/07/2011 13:10, George R. Kasica a écrit :
OK..that gets the file in, but the first 4 rows that are always locked
with Headers get replaced as well even if I say from Line 4, and I've
tried both before and after sheet options. Also there are some calc
lines at the bottom that in Excel are
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 HiLow Out WindWind Hi
Hi Wind Heat THSW
At 07:48 23/07/2011 -0500, George R. Kasica wrote:
I have a currently existing Excel 2007 sheet that I can do a (In
Excel) Refresh All for \\APOLLO\e\WeatherLink\JACW3\download.txt ...
So that's a file available to your system?
... which is a te[x]t file in the format of: [...] and is