|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.71.2016.0"' name=GENERATOR>
</HEAD>
<BODY bgColor=#d8d0c8>
<DIV><FONT color=#000000 size=2>Here it comes ;-)</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT><FONT size=2>BTW what is
Concat?</FONT></DIV>
<DIV><FONT color=#000000 size=2><BR>Greetings from Jan
Diederik</FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">
<DIV><FONT face=Arial size=2><B>-----Original Message-----</B><BR><B>From:
</B>Bill Ford <<A
href="mailto:whford@xxxxxxxxxxxx";>whford@xxxxxxxxxxxx</A>><BR><B>To:
</B>Jan Diederik <<A
href="mailto:jddehaas@xxxxxxx";>jddehaas@xxxxxxx</A>><BR><B>Date:
</B>zaterdag 6 december 1997 14:26<BR><B>Subject: </B>Re: Using Excel to
convert data<BR><BR></DIV></FONT>Jan Diederik wrote:<BR>> In order to use
the data in MS I want to convert that data through<BR>> Excel (97) in the
proper ASCII layout, so I can import it via The<BR>> Downloader. But for
that I need to have the date included. The<BR>> filename of the TXT-files
is xxxYMMDD.txt and I want to use that for<BR>> (automaticly) inserting
in the Excel sheet. I can then save the sheet<BR>> as an ASCII file and
convert it in The Downloader.<BR>> Does anyone know how to create a macro
that that can do it for me<BR>> (manually is waaayyyy to much work). The
data in the files are divided<BR>> by semicolumns and have the following
format:<BR>> Tickersymbol;Open;High;Low;Close;Volume.<BR>> Any help
would be VERY appriciated.<BR>> <BR>> Greetings from Jan
Diederik<BR>Hi Jan<BR>If you email me a sample of your data files that need
to be converted I<BR>will take a look at it. A simple Concat should do
it.<BR><BR>Bill Ford<BR></BLOCKQUOTE></BODY></HTML>
</x-html>
Attachment Converted: "c:\eudora\attach\Ndx71205.txt"
|