System goes to not respond while uploading multiple sheets excel

[manojmathi]

Hi,

I have a scenario to upload multiple sheets excel to SAP.

On that the program works fine when I choose to upload 25 rows at max., when I choose more than 25 rows the system will hang on or goes to not responding or an information message from SAP says 'Application is not responding or is busy ' .

While debugging the SAP will hang on in 'get_ranges_data' method.

error.jpg

error1.jpgerror2.jpg

If any one know Let me know please,

Regards,

Madhivannan

[former_member189059]

Try keeping Excel closed before attempting to run the program. Also make sure that the excel process doesn't exist in the Task Manager.

[former_member182550]

As Kris said...

An application not responding message is normally due to an application that is not polite enough to 'doevents' on a timely enough basis. Also, be aware that using the 'Quit' method for excel does not (or did not) used to quit the program properly and is a constant source of this message.

[Sandra_Rossi]

You probably did something wrong in your program, but how can we help ? You seem to be using DOI (because of method name "get_ranges_data"). Please tell us what you do.

[manojmathi]

Can you please share your mail id. So that I Can send my codes.

[Sandra_Rossi]

No sorry. As per forum rules, the use of the forum implies that the question is fully discussed in the forum and not in private, so that all people seeking for answers can have the whole context and solution.

Please, only attach the relevant code, as a zipped file. Thanks.

[manojmathi]

Please find the attachment. I have attached my code

code.txt