web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Nav 2009 export as excel
Microsoft Dynamics NAV (Archived)

Nav 2009 export as excel

(0) ShareShare
ReportReport
Posted on by AbduTeeyech 428

Hi, I need the excel file (which gets created from Nav Report) to be saved in the computer.

It opens now, and needed to manually save it.

How to export report as excel to computer drive?

Thank you.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    Hi

    To Save Excel automatically refer the below

    http://dynamicsuser.net/forums/p/41734/212753.aspx

    http://erpinfos.blogspot.in/2014/11/navision-2009-excel-create-in-report.html

    and suggested to do search on dynamics forums / google before posting you can find these already

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,005 Super User 2025 Season 2 on at

    Please go through these blogs

    mohana-dynamicsnav.blogspot.in/.../how-to-save-excel-file-automatically.html

    saurav-nav.blogspot.in/.../nav-2013-nav-2013-r2-save-export-to.html

  • AbduTeeyech Profile Picture
    AbduTeeyech 428 on at

    Thank you Rajshekar & Mohana, can you tell me "xlSheet" variable is of what type?.

    'Microsoft Excel 14.0 Object Library'.Sheets. This is wrong I think.

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,005 Super User 2025 Season 2 on at

    Sheet    Automation    'Microsoft Excel 12.0 Object Library'.Worksheet

  • AbduTeeyech Profile Picture
    AbduTeeyech 428 on at

    Thank you, now it is getting saved in the system drive

    It asks for file replace confirmation when we execute second time.

    I tried to add 'today' and 'time' along with the file name, but its showing error while running the report.

    How to set the replace to YES ?

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,005 Super User 2025 Season 2 on at

    Check whether file existing before saving the file and delete if existing

    IF FILE.EXISTS(FileName) THEN

     ERASE(FileName);

  • AbduTeeyech Profile Picture
    AbduTeeyech 428 on at

    Can you tell me what type the file variable is?.

    i have been roaming here there to get it in the excel library. At last I used 'if file.open' of type 'file', nav gets hanged and restarts.

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,005 Super User 2025 Season 2 on at

    you don't have to declare anything. just write above code and compile

  • AbduTeeyech Profile Picture
    AbduTeeyech 428 on at

    Hi Mohana,

    Its done. Now I have a report where the items get exported to excel and csv as well, gona add this to the scheduler.

    Thank you so much.

    -Abdul.

  • AbduTeeyech Profile Picture
    AbduTeeyech 428 on at

    Hi, why the zero is omitting while exporting to excel?.

    eg: item number 00987654 is saved as 987654.

    Is there a property of the excel to set the field format to 'Text' , to make include those zeros'?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans