Neonovaz

yup got that ! Thanks everyone for your guidance ! got it working

Ok so you suggest everytime the script launches, Fileinstall adds the word file to script location, the user can then click and launch it from the script location using the GUI. IF the GUI closes the the file then gets deleted too Something like that?

Thanks But this uses a file stored in a location right? As I understand this code, it basically launches test.doc from desktop when user click in gui Is there any way that you can embed the file in the GUI itself.

Thanks ! As I understand it this will install soem specific files to a location specified (something like a setup) My aim is to embed the file in the tool itself and open it up on user click. (it should not be stored as a seperate file in the script directory)

Hello Is there anyway to store word documents in Autoit GUI? For example I have a instruction sheet that I want to bundle up with the exe. So a user simply clicks the icon and the stored document will launch (Something like how you can add objects like excel sheets in word documents ) (I Know we can launch word files from script directory)

Thanks ! I will try that However for now i did a workaround by sorting the filled cells to the top, counting them and then adding the formula on the other column using the count from the first they start from A2 .. so problem fixed! Thanks everyone for your support and response Topic Closed

Hi Thanks for your response Well The problem with this method is... how do I tell the script where to insert the formula? There is no way to figure out what is the first filtered row number (even for a new column). If somehow we can get the row number of the first/second row that comes up after using filter, then yes i think this might work.

Any ideas? anyone?

Hello Thanks for your response Well the problem with that is I cannot know which row to apply the formula at... (as stated in the topic header) If somehow I can get the 2nd row number (in the filtered column) I can put the formula there and do autofill maybe But problem is how to get that 2nd row number since I have no way of knowing what rows would be filtered out

This is what I want as end result COLB   COLC  1   |  A  2   |  3   |  B  4   |  C On apply filter for All except blanks COLB COLC 1 | A 3 | B 4 | C Final Result COLB COLC A | A B | B C | C Result After Removing Filter COLB COLC A | A 2 | B | B C | C

Hello, Thanks for your response Well to run the whole thing you would require an excel which has some confidential data But what I'm looking for is simple. An excel sheet with columns B and C , Where B has some xyz values in rows 1-20 while Column C has about 10 Values in random rows. The rest are blank in Column C. Now we need to filter all except blanks on Column C (which i have achieved already) and then Copy contents of filtered rows of Column B to Column C (using maybe =B2) and then autofilling the rest of filtered rows in Column C. this is the part I'm stuck at. (tried using Ranged Areas as suggested by Water ) But I can only get the filtered data via it (can't use it to change anything in the actual excel filtered rows)

Any suggestions?

Hello I'm using Excel UDF to filter data in an excel sheet. My aim is to autofill a column with a formula adjacent to the filtered column ((Eg: if filter is on column C, I want to apply autofill formula on column I'm using _Excel_FilterSet to set the filter. However I'm having problem in figuring out how to use autofill here as the filtered range is mixed of random rows which meet the criteria Workaround I have tried I tried using range areas to get the filtered data (as per Excel Wiki), but It doesn't tell me the row number of the first filtered row any advise on how to go about this would be most helpful. Please let me know if some info is needed. My code snippet is below _Excel_FilterSet($oWorkbook6,"NOBYTNBR", Default , 3, "<>", 1) ; $oWorkbook6.Worksheets("NOBYTNBR").Range("C:C").Copy global $oRange = $oWorkbook6.Worksheets("NOBYTNBR").Usedrange.SpecialCells($xlCellTypeVisible) Local $aResult[1][$oRange.columns.Count], $aContent ; Read the data of all Ranges in the Area and concatenate the returned arrays. For $oArea In $oRange.Areas $aContent = _Excel_RangeRead($oWorkbook6, "NOBYTNBR", $oArea, Default, True) _ArrayConcatenate($aResult, $aContent) Next _ArrayDisplay($aResult)