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.......

Thank you very much dude I ll try it and let you know thank you again

Hi all, I am trying to write a script which will check whether open office is installed in a machine or not. If installed it should get the hostname and copy it to text file in c drive.With the below script I am able to get whether open office is installed or not . can anyone please give me some suggestion how can I read value from the variable('$openoffice' in the script) and send the value to text file in c drive. I have 50 machines and I am trying to create a group policy and implement this.If open office is installed the machine's hostname should be redirected to C:\hosts.txt file. If open office is not installed then move to next machine. Please check my script #include<process.au3> if FileExists("C:\Program Files\OpenOffice.org 3\program\") Then $openoffice =RegRead("HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\ComputerName\ActiveComputerName","ComputerName") _RunDOS( "$openoffice > C:\host.txt") Else Exit EndIf using the above script it is reading data from registry. so that we can come to know open office is installed or not.I am trying to use _RUNDOS command to redirect the value from $openoffice to C:\hosts.txt file but I am not able to do that.Please help me out.

Hi all, I have a small doubt... Do we have any function in autoit that will search for a word in any web page and if it founds it, it should click it. Can it be done in autoit?? Please help... I am not asking for searching a word in google using autoit script... but after opening any web page I need to click on a word(which contains web link). Do we have any functions or macros or anything that can fulfill my requirement???

Hi all, There are some files and folders in a network path(Ex: \\computername\share). I want to copy all the files and folders from that path to my system path like C:\Program Files\folder x. For that I have written below attached script and executed it. But I am not able to copy all the folders. All the files were copied but for one folder ,it is not copying at all.All the files were copied. Some of the folders were also copied. Only one folder it is not copying. For that I have created a folder and started copying into it from that network path again.Can anyone please explain why is it not happening.But I am getting the message as copying completed successfully. Please help me. Folder copy.au3

Hi You are trying to uninstall a program from GUI mode. I have done it from deleting some registry keys. I am going to share the script with you now. check if it works for you. This is the example script which uninstalls winzip from your machine. Removing WinZip.au3

Hi, I have downloaded your script but I am unable to use it.Can you please elaborate and explain me how to use this script?? I have compiled the script. When executing the compiled script i got an error like line -1: error: Unknown function name and when executing script error is like OnAutoitExitRegister("Clear") Error: Unknown function name Please give me a reply

Dear all, I need small help in the following script which I am trying to create for adding users into ADS. But I didnt use send key more frequently. SO I am not able to proceed.My intention is when I click on the script it should ask username and organizational unit to add to domain. But I am not able to use the send key correctly.Please check the below script: $rr = InputBox("User Creation","Enter the emp no of the new user:") if @error = 1 Then MsgBox(0,"Exit","User Data Not Modified.") Exit EndIf $rrr = InputBox("Choose OU","Enter the ou at which user needs to be added:") if @error = 1 Then MsgBox(0,"Exit","User Data Not Modified.") Exit EndIf Run("C:\WINDOWS\system32\cmd.exe") sleep(10) Send(" dsadd user ""cn="& $rr &,"ou=" & $rrr &,"dc=",& $tt &,"dc=com"")

Hey dude, this is working very good. I just wanted to know how did folder properties change to open control panel??? and what is that code you have used .{21EC2020-3AEA-1069-A2DD-08002B30309D} Please reply me

Thank you very much. Those tutorials are very helpful. Thanks once again.

Hey dude I am new to autoit and I dont have much idea about the scripting. I have downloaded your original.au3 file and when I double click it, it is throwing an error like "error reading file #include <resources.au3> should I need to download anything else.... please suggest