Atticus

Thanks a lot or your response. I have almost understand. but I still don't understand this line For $n = UBound($avData) - 1 To 1 Step -1 what is -1 to 1 Step -1 Thanks

Thanks but I still don't understand this code, can someone please explain me. I need to understand that code. Please. thanks

Hello everybody, I have a problem. I used a code find on this forum but I don't know how to explain it. Can someone explain me this code line by line please. Global $sFilePath = "\\Server\disqueCD\Commun XP CD\2008\CLIENTS\CREANCES CLTS EN COURS.xls" $sFilePath = FileGetShortName($sFilePath) Global $oExcel = _ExcelBookOpen($sFilePath) Global $avData = _ExcelReadArray($oExcel, 1, 1, 5000, 1, 1) Global $iLastUsed = 0, $iNextRow = 0 For $n = UBound($avData) - 1 To 1 Step -1 If StringStripWS($avData[$n], 8) <> "" Then $iLastUsed = $n ExitLoop EndIf Next If $iLastUsed Then $iNextRow = $iLastUsed + 1 EndIf I thank you by advance

Thanks a lot. One more question: It's the last. what is the function to select a case??? Thanks by advance

I have solved my problem. It was because they were no sheets 1 in my book. I've got one more question: I wanna select in my book all the case which are used , excepted the case from line 1. How can I do that???!!!!

Thank you very much for all your answers. i'm gonna try everything tomorow. Hope it will works. Thanks a lot again.

Any idea?

When I open it manually there is no errors. It's only when I execute the script. I think it is a problem ( it's just a thought) with the include files excelCOM_UDF, maybe an error in the script .....

I work on Excel 2003. Excel launch open my excel book and after 2 or 3 second this message appears !!!!

Thanks a lot, but I've got one more problem I've made this script but when I run it, I've got this error: What is the problem???!!!! I don't understand !!!!

Thanks but I have allready seen this topic but I don't know which of those functions I need to use. I don't understand most of them. If someone can tell me which function I need to use, It could be very nice.

Hello everybody, Sorry for my bad engish but i'll try to understandable. I begin with autoIt and i have seen the work of Locodarwin for the new function for excel. I wanna create a script which copy data from an excel book A to an excel book B. But i'd like that the data are copied in the first empty case a the sheet A from the excel book B. Is it possible. Which function must I use. thanks by advance. Atticus