Search found 43 matches

by sv270190
04 Jul 2017, 21:35
Forum: SciTE4AutoHotkey
Topic: SciTE4AutoHotkey v3.0.06.01 [Updated October 12 2014]
Replies: 776
Views: 336654

Re: SciTE4AutoHotkey v3.0.06.01 [Updated October 12 2014]

Type %var% with minimum key strokes ie key board shortcut for % %
by sv270190
18 Jun 2017, 12:30
Forum: Scripts and Functions
Topic: Reads Excel (xlsx) Fast
Replies: 29
Views: 5662

Re: Reads Excel (xlsx) Fast

kind attention: Blackholyman saving-excel-file-data-to-csv your codes works good. thank you. 1. kindly modify the codes so that the excel file is open and active sheet is saved as csv file 2. all the sheets of the active work book is saved as csv files 3. normal fileselectfile save all sheets as CSV...
by sv270190
18 Jun 2017, 11:48
Forum: Scripts and Functions
Topic: xlFindLastCell() - Find last non-empty cell in Excel
Replies: 6
Views: 2516

Re: xlFindLastCell() - Find last non-empty cell in Excel

GOOD.
can you modify this so that we get the used range say for eg A1:R828
it will further enhance the usefulness of the script
thanks
by sv270190
01 Mar 2017, 08:22
Forum: Tutorials
Topic: Tutorial of some One Line Logic in AutoHotkey
Replies: 9
Views: 7810

Re: Tutorial of some One Line Logic in AutoHotkey

Sorry sir my question is how to run command /function A if va=1. If var=2 run command B if var=3 run, command C like that
by sv270190
06 Feb 2017, 21:06
Forum: Ask For Help
Topic: SQL left JOIN - HOW TO ACHIEVE IT THROUGH AHK
Replies: 4
Views: 859

Re: SQL left JOIN - HOW TO ACHIEVE IT THROUGH AHK

Thank you
Could you convert this as function
For eg
AHK_LEFT_JOIN(F1, F2, F1C, F2C)
by sv270190
06 Feb 2017, 21:02
Forum: Ask For Help
Topic: SQL left JOIN - HOW TO ACHIEVE IT THROUGH AHK
Replies: 4
Views: 859

Re: SQL left JOIN - HOW TO ACHIEVE IT THROUGH AHK

Good. It works.
But sir I could not understand your code
What why
What should I read?
Arrays / objects ??
by sv270190
05 Feb 2017, 11:24
Forum: Ask For Help
Topic: SQL left JOIN - HOW TO ACHIEVE IT THROUGH AHK
Replies: 4
Views: 859

SQL left JOIN - HOW TO ACHIEVE IT THROUGH AHK

TWO FILES ARE THERE F1.TXT AC|NAME 1|RAM 2|RAHIM 3|ROBERT 4|guru 5|raju F2. TXT AC|AMOUNT 1|100 2|200 3|300 WHAT I WANT TO ACHIEVE F3.TXT AC|NAME|AMOUNT 1|RAM|100 2|RAHIM|200 3|ROBERT|300 4|guru| 5|raju| I could achieve the following: AC|NAME|AMOUNT 1|RAM|100 2|RAHIM|200 3|ROBERT|300 through this co...
by sv270190
30 Jan 2017, 10:59
Forum: Ask For Help
Topic: Tool to convert Excel files to CSV
Replies: 8
Views: 2852

Re: Tool to convert Excel files to CSV

Very useful
. Thanks a lot
Xl. Close() and not close(0). Please amend your code

Alerts to be disabled
Once again thanks
by sv270190
28 Jan 2017, 17:40
Forum: Ask For Help
Topic: Tool to convert Excel files to CSV
Replies: 8
Views: 2852

Re: Tool to convert Excel files to CSV

Suppose there are six sheets in the workbook. How can we save all as separate csv file say sheets1. Csv like this
by sv270190
11 Dec 2016, 22:08
Forum: Ask For Help
Topic: AHK & Excel
Replies: 11
Views: 6067

Re: AHK & Excel

Myvar := oxl. Range("a1:b8"). Value
MS box, % myvar does not work
by sv270190
11 Dec 2016, 11:37
Forum: Ask For Help
Topic: Ahk loop read file extremely slow in windows 10
Replies: 14
Views: 1763

Re: Ahk loop read file extremely slow in windows 10

I am really sorry that I can't follow neither of the above examples
Kindly provide contents of two files for sample
And give the likely output in both the cases search term also be given
Not only myself but many fans of ahk will benefit immensely
by sv270190
11 Dec 2016, 07:45
Forum: Scripts and Functions
Topic: Excel Functions
Replies: 2
Views: 1441

Re: Excel Functions

dear sir please clarify I could get the value of range assigned to a variable. I also could assign the same value to another range. but when it comes to fileappend, %myvar%, c:\download\good.txt it fails why myxl := XlObjGet() ;msgbox, % XlActiveCell(myxl,,true) ; Handle [, Window, Contents] ; works...
by sv270190
11 Dec 2016, 06:46
Forum: Ask For Help
Topic: Ahk loop read file extremely slow in windows 10
Replies: 14
Views: 1763

Re: Ahk loop read file extremely slow in windows 10

thanks for your clarification
by sv270190
11 Dec 2016, 05:51
Forum: Ask For Help
Topic: Ahk loop read file extremely slow in windows 10
Replies: 14
Views: 1763

Re: Ahk loop read file extremely slow in windows 10

SIR, resolved the issue - with your help --- a million thanks I USED "Loop,READ,D:\CUSTDET\custdet.TXT,D:\CUSTDET\CUSTDET.RPT" IT took less than a second, so I used a_tickcount 296 milli seconds -- time for execution thanks again for this has solved not only this problem but also it boosted my self ...
by sv270190
11 Dec 2016, 05:11
Forum: Ask For Help
Topic: Ahk loop read file extremely slow in windows 10
Replies: 14
Views: 1763

Re: Ahk loop read file extremely slow in windows 10

" Do you have different antivirus or SATA/AHCI/IDE controller drivers?" 1. WINDOWS DEFENTER is the only antivirus I use in the system. 2. SATA/AHCI/IDE controller drivers ------------- I do not follow. how to know about it. 3. my system is win 10 64x " I would suggest utilising the OutputFile parame...
by sv270190
10 Dec 2016, 12:03
Forum: Ask For Help
Topic: Ahk loop read file extremely slow in windows 10
Replies: 14
Views: 1763

Ahk loop read file extremely slow in windows 10

autohotkey scripts loop read file is extremely slow in windows 10 the same script is fast in win 7. being dead slow it defeats the very purpose of using autohotkey please guide me as to speed up ahk in win 10 also as it worked in win xp and win 7 #SingleInstance, force ListLines,Off SetBatchLines, -...
by sv270190
19 Jun 2015, 11:16
Forum: Scripts and Functions
Topic: mailMerge.ahk
Replies: 3
Views: 1818

Re: mailMerge.ahk

Default path be previous one _____ then very useful

Go to advanced search