<div>
I have resolved the issue by using my mac instead of pc. I simply downloaded the file as a txt file and uploaded it to a linux account then used cat to join the files. I'm still looking to average the files per month. See my other questions.
</div>


I have resolved the issue by using my mac instead of pc. I simply downloaded the file as a txt file and uploaded it to a linux account then used cat to join the files. I'm still looking to average the files per month. See my other questions.

<div>
mwochnick<br />
<br />
A vb macro? I was actually thinking of doing it with VBA, no macros.
</div>


mwochnick

A vb macro? I was actually thinking of doing it with VBA, no macros.

<div>
<div class="content wysiwyg-content">
I am crunching data and need to convert the data from the website <br />
<br />
<a href="http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt" rel="ugc">http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt</a>&nbsp;<br />
<br />
to a xls file. How would I do that?<br />
<br />
&nbsp;Also I am looking at data from this website and need to convert the files to xls format as well. &nbsp;<a href="http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt" rel="ugc">http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt</a>
</div>
</div>


I am crunching data and need to convert the data from the website 

http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt 

to a xls file. How would I do that?

 Also I am looking at data from this website and need to convert the files to xls format as well.  http://lasp.colorado.edu/sorce/tsi_data/daily/sorce_tsi_L3_c24h_latest.txt

converting web .txt or .dat file into an xls file

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.