Well, playing around with XL's macrorecorder I found out I need to add , FileFormat:=xlCSV
whenever I save a .csv file in the macro. Then all goes well. Thanks again for your help. -treliff --- In [email protected], "treliff" <[EMAIL PROTECTED]> wrote: > > Thanks Graham. But where from here? > > When I open the file in Excel it looks pretty normal but when I open > in Notepad it is beyond garbage. > > What the heck happened here? > > All I could think of to possibly convert everything is (in Excel) to > copy all data and then Paste Special everything as "values". Still > garbage. > > Clearly I'm no expert. Do you know how I can somehow force everything > into ASCII ? (I just googled "convert garbage to ascii" and similar > phrases but did not find the answer yet :) > > Appreciate your help! > > -treliff > > --- In [email protected], Graham <kavemanperth@> wrote: > > > > your data file is not ascii text > > > > > > -- > > Cheers > > Graham > > AB-Write >< Professional AFL Writing Service > > Yes, I write AFL code to your requirements > > http://e-wire.net.au/~eb_kavan/ab_write.htm > > > > > > On 11/09/06, treliff <treliff@> wrote: > > > > > > I am trying to ASCII import a .csv file with a custom .format > file and > > > just cannot get it done: none of the tickers is imported at all. > > > > > > I just tried the Import Wizard and after I "Pick files" and > > > click "Next" this is what shows: > > > > > > Data file sample: > > > ÐÏ à¡± > > > > > > I ASCII import all the time without any problem but this > particular > > > file just won't go. > > > > > > It is a .csv file so there is no HTML or anything else that could > > > cause "garbage", at least as far as I know. > > > > > > Has anyone perhaps experienced this and/or know what could cause > this? > > > > > > Thanks! > > > > > > > > > > > > > > > > > > > > > Please note that this group is for discussion between users only. > > > > > > To get support from AmiBroker please send an e-mail directly to > > > SUPPORT {at} amibroker.com > > > > > > For other support material please check also: > > > http://www.amibroker.com/support.html > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Please note that this group is for discussion between users only. To get support from AmiBroker please send an e-mail directly to SUPPORT {at} amibroker.com For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/amibroker/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/amibroker/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
