Printing report to Excel spreadsheet

zkasmani

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.

Luc_VanDyck

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.

Mr_David_Cox

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.

Luc_VanDyck

The file is now available in the download section.