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)

AlexDen 90 on at

Like (0)

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

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
Manikanta_501 245 on at

Like (0)

Report

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

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
Suggested answer

RockwithNav 7,980 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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

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

I Gusti Made Ari 3,594 on at

Like (0)

Report

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

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