AutoHotkey Community

sv270190

A am SRINIVASAN from TAMILNADU. India

sv270190

please modify this code for. openoffice spreadsheet

sv270190

Type %var% with minimum key strokes ie key board shortcut for % %

sv270190

How can I get %var% easily

sv270190

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

sv270190

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

sv270190

Got it thanks

sv270190

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

sv270190

Thank you
Could you convert this as function
For eg
AHK_LEFT_JOIN(F1, F2, F1C, F2C)

sv270190

Thank you

sv270190

Good. It works.
But sir I could not understand your code
What why
What should I read?
Arrays / objects ??

sv270190

sv270190

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

Alerts to be disabled
Once again thanks

sv270190

Suppose there are six sheets in the workbook. How can we save all as separate csv file say sheets1. Csv like this

sv270190

Myvar := oxl. Range("a1:b8"). Value
MS box, % myvar does not work

sv270190

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

sv270190

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

sv270190

thanks for your clarification

sv270190

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

sv270190

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

Search found 45 matches

Re: Is there anyone from India?

Re: Tool to convert Excel files to CSV

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

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

Re: Reads Excel (xlsx) Fast

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

Re: Tutorial of some One Line Logic in AutoHotkey

Re: Tutorial of some One Line Logic in AutoHotkey

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

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

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

SQL left JOIN - HOW TO ACHIEVE IT THROUGH AHK

Re: Tool to convert Excel files to CSV

Re: Tool to convert Excel files to CSV

Re: AHK & Excel

Re: Ahk loop read file extremely slow in windows 10

Re: Excel Functions

Re: Ahk loop read file extremely slow in windows 10

Re: Ahk loop read file extremely slow in windows 10

Re: Ahk loop read file extremely slow in windows 10