Rapid Start Import Error

Business Central/NAV Technical Forum
9

Hi Thomas,

I don’t know if this is the same case, this error can ocurr if there isn’t installed Excel in the computer, or the user have no permissions to use Excel. In my case, a client had installed LibreOffice and got this error.

The error apears in, exactly, the moment when tries to open excel (Function CallOpen)… You can change code to download file instead to try to open it.

This is a function I added to Excel Buffer to do that (NAV 2013R2):

DownloadExcel()
ClientFilename := 'Book1' + ExcelFileExtensionTok;

IF FileManagement.CanRunDotNetOnClient THEN BEGIN
  ClientFilename := FileManagement.SaveFileDialog('Save file','',Text034);
  IF ClientFilename = '' THEN
    EXIT;
  IF FileManagement.GetExtension(ClientFilename) = '' THEN
    ClientFilename += ExcelFileExtensionTok;
END;

FileManagement.DownloadToFile(FileNameServer,ClientFilename);