Small and medium business | Business Central, N...

How to Saveas() Excel file without asking Do you want to Replace Existing File Message.

(0) Share

Report

Posted on by Manikanta_501

245

Hello Experts,

How can we do Saveas() a Excel file Directly without displaying confirmation message (by Writing Code-unit).

Thank you.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

I Gusti Made Ari 3,608 on at

Like (0)

Report
Copy link

Link copied!

Use Outstream , sample code :

File.CREATE('C:\YourExcelFile.xls');

File.CREATEOUTSTREAM(Outstr);

YourRec.SETFRANGE("FIeld 1",Filter1);

IF YourRef.FINDFIRST THEN BEGIN

RecordRef.SETTABLE(YourRec);

REPORT.SAVEAS(REPORT::"Your Report Name",'',REPORTFORMAT::Excel,OutStr,RecordRef)

END;

https://docs.microsoft.com/en-us/dynamics-nav/createoutstream-function--file-

FIle.CLOSE

Was this reply helpful? Yes No
Manikanta_501 245 on at

Like (0)

Report
Copy link

Link copied!

Thanks for Your Replay,

Actually I am Unprotecting the Excel file & Saving that file in same path. The code is like below.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,947 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Ideally this Message will only come when you already have a file at that location with the same name so technically this is a correct message, if want to get rid of this message then you need to first check if that file already exist there and if yes then you need to move or delete that file.

Was this reply helpful? Yes No
Manikanta_501 245 on at

Like (0)

Report
Copy link

Link copied!

As you said , I modified code as like below(added code for Deleting existing file from local system).

But while running this code I am getting error , below.

Was this reply helpful? Yes No
AlexDen 90 on at

Like (0)

Report
Copy link

Link copied!
Hello,

Try to use Save() instead of SaveAs().

Or set DisplayAlerts to False before saving the file:

ExcelApplicationClass.DisplayAlerts := FALSE; ExcelWorkbook.SaveAs(); ExcelApplicationClass.DisplayAlerts := TRUE;

Was this reply helpful? Yes No