You’re offline. This is a read only version of the page.
Writing to excel file throws error Exception from HRESULT: 0x800A03EC
Really the comment in this case belong to a "missed Drive letter"; so the explaination provided is fine, obviouly with the Monday Newspaper.
mind blowing.... who would have thought? Thanks a lot!
A quick google search indicates that the error can be related to several things in Excel: "The error code
(or -2146827284) means NAME_NOT_FOUND; in other words, you've asked for something, and Excel can't find it."
Could it be that what you are trying to write to Excel does not conform to the size or format of the sheet? I see that you populate the DownloadedFiles-variable with other variables - this might be part of the issue? Could be that the list is longer than what fits into the sheet or the format isn't accepted?
Sure! - there are a couple of booleans.... but you can ignore the ifs part.
Thanks!
Excel.LaunchExcel.LaunchAndOpen Path: DocumentsUploadedFilePath Visible: False ReadOnly: False LoadAddInsAndMacros: False Instance=> UpdateReport
Excel.ReadFromExcel.ReadAllCells Instance: UpdateReport ReadAsText: False FirstLineIsHeader: True RangeValue=> DownloadedFiles
Excel.CloseExcel.Close Instance: UpdateReport
LOOP FOREACH CurrentDownloadedFile IN DownloadedFiles
IF CurrentDownloadedFile[0] = SalesNatXMLFilePath THEN
DISABLE SET DownloadedFiles[LoopRowCount - 2] TO FileNat
SET boolNewFileNat TO $'''False'''
END
IF CurrentDownloadedFile[0] = SalesJudXMLFilePath THEN
DISABLE SET DownloadedFiles[LoopRowCount - 2] TO FileJudStatus
SET boolNewFileNat TO $'''False'''
END
Variables.IncreaseVariable Value: LoopRowCount IncrementValue: 1 IncreasedValue=> LoopRowCount
END
IF boolNewFileNat = $'''True''' THEN
SET DownloadedFiles TO DownloadedFiles + [SalesNatXMLFilePath, FileNatStatus, Date]
Variables.IncreaseVariable Value: LoopRowCount IncrementValue: 1 IncreasedValue=> LoopRowCount
END
IF boolNewFileJud = $'''True''' THEN
SET DownloadedFiles TO DownloadedFiles + [SalesJudXMLFilePath, FileJudStatus, Date]
END
WAIT 2
System.TerminateProcess.TerminateProcessByName ProcessName: $'''EXCEL'''
WAIT 2
Excel.LaunchExcel.Launch Visible: False LoadAddInsAndMacros: False Instance=> WriteUpdate
Excel.WriteToExcel.WriteCell Instance: WriteUpdate Value: DownloadedFiles Column: $'''A''' Row: 0
Excel.SaveExcel.SaveAs Instance: WriteUpdate DocumentFormat: Excel.ExcelFormat.FromExtension DocumentPath: DocumentsUploadedFilePath
Excel.CloseExcel.Close Instance: WriteUpdate
Share
Report
All responses (
Answers (
3