Timo

Hi, I still have the same problem. @PsaltyDS: You are right, there are hundreds or thousand of threads and I'm reading and reading but I can't find a solution which I understand. Isn't there a small tutorial or some sample scripts which will work from the start? It would be very very nice if someone could please help us. Thanks, Timo

Hello, can someone please help me to get your script working? I've tried and tried but I still have the problem by creating the crystalruntime-object. I think I need a step by step explanation, I'm to silly.... My system: MS Vista, CrystalReports Developer 8.5. Thanks, Timo

Hello rasim, thank you for your help.

I found it..... #include <Date.au3> _DateAdd ( $sType, $iValToAdd, $sDate ) Great function. Sorry. Timo.

Hello, I want to get the date of yesterday (06.10.2007). Is there a function in AutoIt, or a function like date_to_num and num_to_date e.g.? Whow do you get the correct date? I can't find a solution in the forum. Is it right? Many thanks. Timo

Great. Thanks.

Many thanks Manadar. Good idea, much easier than StringFormat. But what about SF? Is this not possible with it?

Can you please give me an example? My English ist not the best, I tried but but I did not get it to work. It would be very nice if you could help me. Thanks, Timo

Hi, I need your help. I have a number in the format "4.160,00" and I want to convert it to "4160" or "4160.00". I've studied the help (StringFormat), but I didn't find a solution... Can someone help me please? Bye, Timo

Right. It doesn´t.

Hi, after some months I´m back. I now want to write my own adressbook with autoit. The GUI is top, so let's try. I want to use my contacts from MS Outlook. I can export them into access and have a *.mdb with all my data. But how can I use this mdb with AutoIt? How can I use the data inside? Where do I store my new contacts in? I will use a database. Shall i use the Access-Format mdb or shall I perhaps use sqlite? Has someone of the professionals some hints / tipps for me? I'm sure that certainly someone knows how to manage this the best way... Thanks, Timo

Has anyone an example how to connect AutoIt and Access? Would be very nice....

Hi Burrup, your idea with the 'GUICtrlCreateListViewItem' is fine. That makes sense. Thanks. But the problem with the empty lines still exists. In the excelsheet there are complete empty lines; with your check wether '$string' is empty we check every cell. Here's a short example of my problem, the second and the fourth line should be deleted but I need the empty cell in the last line for calculation: A1 B1 C1 D1 E1 0 0 0 0 0 A3 B3 C3 D3 E3 0 0 0 0 0 A5 B6 0 0 E6 Hm...

Hello together, I read from Excel via COM my data into an array and display it in a ListView. Thats works fine. But in the excelfile there a some empty lines. I don't know how to get them out. Has anyone an idea who to filter them so that I can delete them from the array? $CellRange = "A1:P50" $oExcelDoc = ObjGet($dateiname) $oDocument = $oExcelDoc.Worksheets(1) $array_lrl = $odocument.range($CellRange).value $string = "" For $y = 0 to Ubound($array_lrl,2)-1 $trennzeichen="" GUICtrlCreateListViewItem ("",$liste) For $x = 0 to Ubound ($array_lrl,1)-1 $string = $array_lrl[$x][$y] GUICtrlSetData (-1, $trennzeichen & $string) $trennzeichen = $trennzeichen & "|" Next Next

Wow. That's it, Sven. Fantastic, we have a host of possibilities... I go programming... Thanks a lot.