when you are saving select ascii and then select all files and save as filename.xls
--- allanwallis <[EMAIL PROTECTED]> wrote: --------------------------------- Hi I would be suprised if you cant do this by printing to an ascii file and then importing as a Tab separated file. Consider using AtlasXL it is a far more elegant way of accessing Axapta Data within Excel Hope this helps --- In [EMAIL PROTECTED], "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > Hi , > > I am trying to export Trail Balance Sheet ( basiclly trying to save the query output as a file) in Excel Sheet. But, the options that already there are ASCII, HTML , RTF and PDF. > > I have the following options to convert them to Excel file: > > 1. We can save the .html file and save as .xls > > 2. Save as TXT and export to excel format. ( But its not working properly) > > > > Is there any way to export the data directly into EXCEL format?. I am willing to write some code also. > > Does anyone know about this?. > > Many thanks, > > Ottawa > > > --------------------------------- > Do you Yahoo!? > Yahoo! Mail - 50x more storage than other providers! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> 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/