chaitanyagutala

Dear all, I have a script with which I am writing data to 2 excel files simultaneously.In that script I am using @scriptdir command.While using this cmd, I have 2 excel files and script in one folder and @scriptdir command worked fine.But now I am going to change excels to two different folders. One onto my desktop and other to subfolder in desktop.For this I am replacing @scriptdir with @desktopdir but it is not working.Moreover, while writing to data in excel in desktop, it is overwriting and it is visible.Please help me out in this reg.Thanks and Regards

Thank you very much dude. This is what I want exactly. Thank you once again

Hey dude, I have changed the script you gave at 2 places and it is working fine as per my requirement. But it is writing values only until 27 lines in excel file after that it is going to first line again and overwriting data in it. we will have data loss after 27 lines.Please help me out in this regard dude. Please check the below script. Enter value 30 times and check. After 27 lines first lines are getting overwritten.I dont know why it is stopping at 27 lines only. Please check and do the needful dude. Thanks in advance. #include <Excel.au3> #include <array.au3> $filename = "friends.xls" global $newnames[1],$newnumbers[1] while 1 $name = InputBox("Contact Details","Name:") if StringCompare($name,"exit") = 0 Then ExitLoop $number = InputBox($name & "'s number","Number:") _ArrayAdd($newnames,$name) _ArrayAdd($newnumbers,$number) WEnd if FileExists($filename) = 1 Then $excelobj = _ExcelBookOpen(@ScriptDir &"\" &$filename,0) $k = 0 Do ;Find first open column $k += 1 $val = _ExcelReadCell($excelobj,1,$k) Until $val = "" Else $k=1 $excelobj = _ExcelBookNew() ;Create new book, make it visible EndIf For $i = 1 To UBound($newnames) - 1 _ExcelWriteCell($excelobj, $newnames[$i], $k,1) ;Write to the Cell _ExcelWriteCell($excelobj, $newnumbers[$i],$k,2) $k+=1 Next _ExcelBookSaveAs($excelobj, @ScriptDir & "\" & $filename, "xls", 0, 1) ; _ExcelBookClose($excelobj)

I am not using any text file and I am not importing anything. when we click on the exe it should ask for ur name and then it should ask for mobile number. Both should be copied to an xls file in row wise. But in my script it is entered in column wise.I am trying to use _excelwritecell function. But I am getting some problem in using it. can u give me some examples in using it? I tried in help file but no use.

Dear all, My requirement is I want to collect all my friend's name and mobile number in a xls form.For that I have script which is attached below(Friends details.au3). If I am using it, the data is being entered in the xls file in column form. I want to enter it in row wise. If you want to test the below attached script, type your name, click on click here button,then esc key or close button. Then second dialogue box prompts to enter mobile number. Type mobile number and click esc.An .xls file called friends details will be created in the folder where the script is there.Can anyone please help me out. For your better understanding of my problem, I am attaching two autoit attachments(As I am not able to upload excel forms in this page, I am uploading the same in an au3 file)."saving as" and "need to save". "Saving as" is the file in which it is getting saved with my script and "need to save" is the file in which I need. Please help me out in this regard. Friends details.au3 Saving as.au3 Need to save.au3

I want to change it to chaitanya_gutala.

I found where I am confusing all of you. It is my mistake that I didnt tell you my correct problem. First of all I will open the site http://www.autoitscript.com/forum/index.php?, If I want to login I will click on signin option. Then I will be prompted for username and password to enter into the above site(autoit forums). Then I give user name as chaitanyakumar and my password. Now I want to change this name(chaitanyakumar) and give something else. How can I do that? Thats what I am asking. By the by someof you people are telling me to PM valik. what is this PM?

I want to change autoit forum name only. Please tell me how to do that

Please excuse me for not telling u my problem clearly.... I am talking about autoit user name.

Thats working dude. Thank u very much

Hi all, I am not sure whether this is the correct category to submit my doubt or not. Can anyone please help me out .. how to change the user name? Now my username is chaitanyakumar. I want to change it to someother name. Please tell me how to change user name not display name. Thanks in advance.

First of all please excuse me for my hard reply to you. I tried with the script you gave me. Even that is also not working. I ll tell u my requirement exactly. I have 4--5 folders in the path C:\Program Files\Common Files\Symantec Shared\VirusDefs. when I use dirremove to delete old symantec virus definitions, there are some dll files in one of the folders and they are used by symantec now. so dirremove is not able to delete that particular folder.And the folder which has the dll files(which are currently used by symantec) is the first folder and so all the other folders are not getting deleted.Now my concern is if first folder is not deleted, then it should leave that folder and move to next folder and try deleting that.Can this be possible? One more thing to add, all the folder names will start with year then date and month(20102204.022 like this).So if I use 2* something like this, that also will not work. Please help me out.

If manual deletion comes into scene then there is no way for scripting boss. we can delete those folders manually. But I want it to be done by script. Please tell me whether my requirement is possible or not.

Already I have tried using dirremove function only but no use.I guess filedelete doesnt remove folders isnt it?

Hi all, I have a very small problem. I am trying to write a script which would delete old symantec virus updates folders in the path C:\Program Files\Common Files\Symantec Shared\VirusDefs.Already existing old definition files will have some dll files. By this reason if I use dircopy it is not deleting the files.For my badluck the first folder itself is having some dll files and it is not deleting any of the old folders.Now my requirement is if it is not able to delete one folder it should move to another folder and delete that.Can anyone help me out please.......