Re: Using Excel to convert data

["Jan Diederik" <jddehaas@xxxxxxx>]

Of course I will ;-) A macro is a set of commando which are executed
whenever you choose to. So when you have a task that reoccurs regularly,
it's a good thing to write a macro. That way you only have to specify what
to do ones, and all the other times you can have all those actions performed
by clicking a button ones!

Greetings from Jan Diederik
-----Original Message-----
From: A.J. Maas <anthmaas@xxxxxx>
To: Jan Diederik <jddehaas@xxxxxxx>
Cc: metastock-list <metastock-list@xxxxxxxxxxxxx>
Date: maandag 8 december 1997 20:54
Subject: Re: Using Excel to convert data


Jan,
when succesful, can you send your 'macro', whatever that is,
to the ms-list as an attachment? I would like to try it out.

concerning WCB, I have no experience with it, it looks indeed
very complicated, but thought it might help.
Ton
-----Oorspronkelijk bericht-----
    Van: Jan Diederik <jddehaas@xxxxxxx>
    Aan: Metastock <metastock-list@xxxxxxxxxxxxx>
    Datum: maandag 8 december 1997 19:09
    Onderwerp: Re: Using Excel to convert data


    Thanks, that's what I was looking for. I am now experimenting to compose
the whole macro.

    Greetings from Jan Diederik
    -----Original Message-----
        From: Matt Tway <mtway@xxxxxxxxxxx>
        To: Jan Diederik <jddehaas@xxxxxxx>
        Cc: metastock-list@xxxxxxxxxxxxx <metastock-list@xxxxxxxxxxxxx>
        Date: zaterdag 6 december 1997 17:15
        Subject: Re: Using Excel to convert data


        using the "ActiveWorkbook.Name" Visual Basic function in Excel you
can get your file name, you sould be able to extract the date from the text.

        At 10:33 PM 12/5/97 +0100, you wrote:
        >>>>

        In order to use the data in MS I want to convert that data through
Excel (97) in the proper ASCII layout, so I can import it via The
Downloader. But for that I need to have the date included. The filename of
the TXT-files is xxxYMMDD.txt and I want to use that for (automaticly)
inserting in the Excel sheet. I can then save the sheet as an ASCII file and
convert it in The Downloader.
            Does anyone know how to create a macro that that can do it for
me (manually is waaayyyy to much work). The data in the files are divided by
semicolumns and have the following format:
            Tickersymbol;Open;High;Low;Close;Volume.
            Any help would be VERY appriciated.

            Greetings from Jan Diederik


            <<<<



        * Matthew P. Tway * mailto:mtway@xxxxxxxxxxx *
http://www.rscubed.com/~mtway *
        * No unsolicited E-Mail *