|
PureBytes Links
Trading Reference Links
|
thanks, I did a bit more searching of my memory of excel and recalled
the Data-Import which allows to refresh the data from the external
files. thus no need to open, copy/paste and close 30+ files for ticker
lists.
On Fri, 18 Feb 2005 09:19:53 +0100, tintin92 <tintin922002@xxxxxxxx> wrote:
>
> Hi Graham,
>
> I dont know if I well understand the question.
> I am not fluent in enghish.
> Translate tableau to table maybe.
> Tableau is the french word.
>
> If I have to do the job you are trying to do, I process this way.
>
> Open Word.
> Copy your files in Word.
> Choose : Edit / Select all.
> Choose : Tableau / Convert / Text to Tableau
> Then choose the right separator to you.
>
> Choose : Edit / Select all.
> Choose : Edit / Copy
>
> Open Excel
> Choose one cell
> Choose : Edit / Past
>
> Tintin92
>
>
> ----- Original Message -----
> From: "Graham" <kavemanperth@xxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Friday, February 18, 2005 2:24 AM
> Subject: [amibroker] OT - Copying ticker list txt files to excel
>
> >
> > I am wanting to pull lists from separate txt files into columns in
> > excel. The txt files are separate files for each industry ticker list.
> > Unfortunately I am not yet proficient at excel macros or scripts to be
> > able to do this and was hoping someone would be able to help. I was
> > able to record a macro to do this but it is clumsy and not exactly
> > what I wanted.
> > Once in Excel I can organise them into a full industry list for
> > importing to AB sectors.
> >
> > --
> > Cheers
> > Graham
> > http://e-wire.net.au/~eb_kavan/
> >
>
>
> Check AmiBroker web page at:
> http://www.amibroker.com/
>
> Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> Yahoo! Groups Links
>
>
>
>
>
--
Cheers
Graham
http://e-wire.net.au/~eb_kavan/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|