"Excel has stopped working" during Ranorex test

Ask general questions here.
Posts: 27
Joined: Tue Jun 07, 2016 9:59 pm

"Excel has stopped working" during Ranorex test

Post by karltinsly » Mon Apr 29, 2019 7:31 pm

I have a test that exports data to Excel, manipulates the data, then imports some other data from a text file. About a quarter of the time, Excel will suddenly crashes, with the message "Excel has stopped working" which breaks the test. Any idea of what could cause this? This happens in two different test suites that export data to Excel. Here are the steps in a little more detail.

Open AUT.
Look up data and use built-in export function to export data to CSV.
Open the CSV file in Excel.
Save the CSV file as XLSX file.
Open second Excel file with macros.
Call an Excel macro that deletes some columns.
Use Excel commands to import data from a text file. <--Excel crashes.

I'm especially puzzled because it doesn't happen every time. Any help would be appreciated.

User avatar
Support Team
Site Admin
Site Admin
Posts: 12169
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA

Re: "Excel has stopped working" during Ranorex test

Post by Support Team » Tue Apr 30, 2019 7:49 pm

Hello karltinsly,

Are you able to reproduce the issue by manually performing the steps without Ranorex Studio? If you are not able to reproduce the error manually I recommend creating a support query here - https://www.ranorex.com/support-query/ as the issue may require further investigation. I recommend providing as much information as possible including windows logs.