rameshkumar

Hi, I prepared script which will gather all files information(i.e No.of files, size of each file etc.,) from listed drive and update to a excel sheet. But during that process, if any of the folder having access permissions set to only specific user, then that folder content isn't accessible. Script shows NILL when accessed that folder. Is there any way to override this. Plz hlp...

I Guess, _ReplaceStringInFile() function won't consider RegEx pattern. That causes your problem. First replace characters using StringRegExpReplace() function and then write to new file will rectify ur issue. -cheers ramesh

Thanks Dude...its help me alot... Once again thanks...

Thanks a lot dude. It works.

Hi Chaitu, A small mistake you had done at: Case $msg = $n2 $menustate = GUICtrlRead($menu1) ; return the state of the menu item After OK button, clicked you need to read from list and not from menu. So correct it as follows and it will work: Case $msg = $n2 $menustate = GUICtrlRead($n1) ; return the state of the menu item Also, my suggession during MOVE operation is to use FILECOPY() command instead of DIRCOPY(). Have a good day dude. -regards, Ramesh K

Hi All, Whenever we try to run a Auto IT Script, its presence is identified with icon shown in System Tray Bar. So, it is possible to pause the script using that icon shown. I wan't to run the script which should not be stopped. So, I created a script which run as a Service. But it is identified at Tray Bar. Is there any option to hide that icon to appear at Tray Bar? Please help regarding this one.

Detailed clarification to add colors: $cRow ; represents row $cCol ; represents column $cColorPallet ; represents color pallet number. $sCol = Chr(64 + $cCol) $oExcel.ActiveSheet.Range($sCol & $cRow).Interior.ColorIndex = $cColorPallet Color Pallets:

Thanks dude. It really helps me a lot. Thanks again.

Hi, I prepared a script which will read processes information to an excel sheet. My problem here is, from that excel sheet, I want to set color to a specific cell which meets the requirements. But here it is possible to do font settings like BOLD, UNDERLINE, ITALIC only. Can any one help me in how to set different colors to cells in the excel sheet read?