Thanks Dick, that works, I have stored this procedure for future emergencies.
Meanwhile I found the root of my problem in ActiveWorkbook.SaveAs FileName:="C:\myfile.csv" that I use in the Marco to format the data for AB import. Apparently under certain circumstances this does not save the file as an ASCII file (?? I'm a rookie in this field). Simply adding , FileFormat:=xlCSV prevents the problem and the resulting file is ready for import. -treliff --- In [email protected], "areehoi" <[EMAIL PROTECTED]> wrote: > > You need to convert your data in the Excel file to ASCII. Copy an past > t in Word then convert to table then back too text (comma delimited) > and save as text. If you havent done this no doubt that's the problem. > > Dick H. > > --- In [email protected], "treliff" <treliff@> 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/
