Is there anything Excel isn't a good tool for?

Well, it can't brew coffee - yet.

I regularly use Excel when I need to analyze AX internals like table setup or the cross reference. So I thought I'd share one of my jobs with you and hopefully you will find it inspiring.

I just want to show you the principles so it is really not that important what the attached job does, but it extracts information about the fields in the LedgerJournalTrans table and, of course, exports the information to a new Excel spreadsheet.

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at https://www.microsoft.com/info/cpyright.htm

LJTFieldsToExcel.xpo

Comments

• Anonymous
  July 10, 2006
  Hello,
  i made some modifications to the job so that you can select the table during job run instead of editing the job everytime.
  
  If you are interested in, here its is:
  http://www.keybs.de/unlinked/cahor/Modified_Job_LJTFieldsToExcel.xpo
  
  Regards,
  Carsten Horlacher

• Anonymous
  July 12, 2006
  Extremely usefull, thx Palle

• Anonymous
  July 26, 2006
  Hi
  
    I have some addition to it,
  just check out in my blog http://spaces.msn.com/casperkamal

• Anonymous
  January 18, 2009
  PingBack from http://www.keyongtech.com/314859-excel-open-spreadsheet-com-error

• Anonymous
  January 21, 2009
  PingBack from http://www.keyongtech.com/313163-excel-using-com-in-axapta

• Anonymous
  June 16, 2009
  PingBack from http://workfromhomecareer.info/story.php?id=11964