sree161

Hi , i have tried this, $oRange = $oExcel.ActiveSheet.Range("A:A") MsgBox(4096, "Excel Count Non-Blank Cells", $oExcel.WorksheetFunction.CountA($oRange)) Now i am getting total count of columns..but not filtered ones.. Will any edit in this help?

How can i get the column count post filtering?? Post filtering i have to remove filter.

Hi, i have an excel with data from A to MX. I have to apply filter for all rows and filter N to specific term say "Yes" and take count of number of rows in that filter. Later i have to remove that filter. I am not sure where to add that "Yes" term in Excel_FilterSet ( $oWorkbook, $vWorksheet, $vRange, $iField [, $sCriteria1 = Default [, $iOperator = Default [, $sCriteria2 = Default]]] ) Any suggestions and ideas??

Hi, i have read a note pad and separated data in it using one seperater. i output is in array $s[1], $s[2], $s[3], $s[4], $s[5]....$s[12]. i want to send anyone of odd or even arrays to new notepad. can someone suggest some logic??? i am done till below code

ya i need the script to get the location of the file when i select any file from any other location i.e. windows explorer I used hotkey as posted in above comments

Hi Larsj, is there a way to get the location of selected file into a variable?? i tried to run the example script given in step1 and i jus wanted to know what are the variables that hold the location of focused file??

no i am selecting a file from windows explorer...i need to pull the location of the file to a variable

sure

ya exactly...i am going to select a notepad file. the location of notepad should be copied to that variable.

i am select a file a running a hot key which is set before. i need to assign the location of the selected document to a variable. below is my complete program. HotKeySet('h', 'HotKey1') While 1 sleep(5) WEnd Func HotKey1() ConsoleWrite("n:" & @CRLF) $a = @ProgramFilesDir $b = @ProgramsDir $f = @filedir ; i need to assign the location of selected file to this variable and display it. MsgBox(0, "", $a) MsgBox(0, "", $b) EndFunc

Hi all, how can i get the location of selected file into a variable?? I tried all these but i didn't get desired output $a = @ProgramFilesDir $b = @ProgramsDir MsgBox(0, "", $a) MsgBox(0, "", $b)

I checked in GUI help topic on the same seems tricky for a beginner. Any other suggestions on how can I try??

This worked. Thanks a lot

Hi all, Thanks for the suggestions. I have learnt to use all those parameters. I am struck with a problem. I am running a loop, which gives 2 values at the end and have to copy this to excel. Each time the loop gives a output I am able to paste in A2 , B2 as I set those How can I automatically jump to next line i.e A3 ,B3 for next loop output??? Any logics plzz?? Thanks in advance, Sree161

But it doen't tell how to paste it in specific cell?? any special command to do that??