Printing report to Excel spreadsheet

zkasmani
zkasmani Member Posts: 5
edited 2000-06-01 in Navision Financials
Hi there. I'd appreciate help on exporting a printout to an Excel spreadsheet. Specifically, I'd like to produce the customer ageing report from Navision and then access the file from Excel in order to use it for further processing.

Thanks.

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    If you have Navision Financials 2.00, you can use "Save As HTML" to save the report in a HTML-ASCII-file. You can import that file then in Excel. If you have an older version of NF, you can try printing to a text-printer. The result is also an ASCII-file, you can import.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Mr_David_Cox
    Mr_David_Cox Member Posts: 15
    Hi Zkasmani
    I have uploaded an Excel automation example for you!
    If is accepted you can download it, if not email me and I will forward it to you!

    Note:
    Nice site webmaster, I miss NOLUG so I will be adding this site to my bookmarks.
    MindSource(UK)Limited
    Navision Service Partner
    info@mindsource.co.uk
    www.mindsource.co.uk
  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    The file is now available in the download section.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)

Categories