Search found 160 matches

by Marcosa1020
20 Jan 2019, 00:37
Forum: Ask For Help
Topic: Find keywords and fill in strings.... Topic is solved
Replies: 12
Views: 2232

Re: Find keywords and fill in strings.... Topic is solved

Hi @IMEime,
I'm very sorry. I'm not familiar with the AHK language.
If I can understand your code(VBA code ?), I will use it. Of course why not.
I can not use VBA in my work, because this is related to permissions.
I'm very grateful for your help. :salute:
by Marcosa1020
19 Jan 2019, 22:13
Forum: Ask For Help
Topic: Find keywords and fill in strings.... Topic is solved
Replies: 12
Views: 2232

Re: Find keywords and fill in strings.... Topic is solved

Hi, This is a modified script. When I input number 11、Type-A、Type-B. https://www.autohotkey.com/boards/download/file.php?mode=view&id=6394&sid=b2e37822d9047d39e41c061d4eb1cfaa I still can't search number 11 and fill in vcard1 and vcard2. https://www.autohotkey.com/boards/download/file.php?mode=view&...
by Marcosa1020
19 Jan 2019, 06:49
Forum: Ask For Help
Topic: Find keywords and fill in strings.... Topic is solved
Replies: 12
Views: 2232

Re: Find keywords and fill in strings.... Topic is solved

Hi @IMEime,
First, thank you for your reply, but I still don't understand. :headwall:
Because of my work relationship, I have to use AHK instead of VBA, and I will keep trying.
Finally, I wish you a wonderful day. :thumbup:
by Marcosa1020
19 Jan 2019, 06:00
Forum: Ask For Help
Topic: Find keywords and fill in strings.... Topic is solved
Replies: 12
Views: 2232

Re: Find keywords and fill in strings.... Topic is solved

Hi, I tried to modify the script but still have no function. Can you help me? #NoTrayIcon Gui +AlwaysOnTop Gui, Color, FFFFFF Gui, Font, S10 EEAA99, Tahoma Gui, Show, x131 y91 h250 w150,Test Gui, Add, Text, x5 y15 c000000, Item-A Gui, Font, S14 EEAA99, Tahoma Gui, Add, Edit, x50 y10 w50 h25 vCard1 G...
by Marcosa1020
19 Jan 2019, 03:33
Forum: Ask For Help
Topic: Find keywords and fill in strings.... Topic is solved
Replies: 12
Views: 2232

Re: Find keywords and fill in strings.... Topic is solved

coffee wrote:
19 Jan 2019, 03:29
It was an example on "how-to", not an exhaustive drop-in solution, you need to read the comments and take what you need, then apply it to your script.
Hi coffee,

Ok, I will try to modify my script. Thank you, have a nice day.
by Marcosa1020
19 Jan 2019, 03:24
Forum: Ask For Help
Topic: Find keywords and fill in strings.... Topic is solved
Replies: 12
Views: 2232

Re: Find keywords and fill in strings.... Topic is solved

When using excel COM sometimes it can be a good idea to set excel to R1C1 notation in the excel options so you can visualize what you want and then work straight with integers, instead of lettered columns. You can use numbers as pseudo pointers that you can increase decrease as needed. Or simply vi...
by Marcosa1020
19 Jan 2019, 01:45
Forum: Ask For Help
Topic: Find keywords and fill in strings.... Topic is solved
Replies: 12
Views: 2232

Find keywords and fill in strings.... Topic is solved

Hello, This is my script and it has some features not completed, please help me. Thank you, have a nice day. #NoTrayIcon Gui +AlwaysOnTop Gui, Color, FFFFFF Gui, Font, S10 EEAA99, Tahoma Gui, Show, x131 y91 h250 w150,Test Gui, Add, Text, x5 y15 c000000, Item-A Gui, Font, S14 EEAA99, Tahoma Gui, Add,...
by Marcosa1020
11 Feb 2018, 01:55
Forum: Ask For Help
Topic: How to sort excel ? Topic is solved
Replies: 5
Views: 1583

Re: How to sort excel ? Topic is solved

I tried to run these codes as below, but it can not be running. :headwall: wb0.ActiveSheet.Range("A2:L999").Sort() ; I have changed wb1 to wb0, because the FormatTime in A.xlsx wb0.ActiveSheet.Range("A2:L999").Sort("A1") The MSDN says all the parameters are optional which I assumed would make it so...
by Marcosa1020
27 Jan 2018, 10:10
Forum: Ask For Help
Topic: How to sort excel ? Topic is solved
Replies: 5
Views: 1583

Re: How to sort excel ? Topic is solved

Only glanced at your code but maybe this will help: wb1.ActiveSheet.Range("A2:L999").Sort() I believe the defaults will get you what you want but here are all the parameters that can be used. https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-sort-method-excel FG Hi, I tried to run these...
by Marcosa1020
27 Jan 2018, 00:52
Forum: Ask For Help
Topic: How to sort excel ? Topic is solved
Replies: 5
Views: 1583

How to sort excel ? Topic is solved

Hi When I press button submit, and then open the A.xlsx excel file at C:\Test\A.xlsx , I can get like photo_1. Photo_1.jpg Could you tell me how can I to sort A.xlsx from column A2 to L999 by date and order by newest to oldest , when I open the A.xlsx file before ? Just like photo_2. Thank a lot. Ph...
by Marcosa1020
11 Jan 2018, 09:10
Forum: Ask For Help
Topic: The window change
Replies: 4
Views: 977

Re: The window change

See below... Another way to write your script: #SingleInstance, Force #NoTrayIcon Gui, Font, S10 C000000, Tahoma Gui, Add, DropDownList, x60 y88 w40 h200 vD1, A||B|C Gui, Show, x300 y100 h400 w400, Window_C Gui, MyGui: +AlwaysOnTop -Caption +Border Gui, MyGui: Color, CFFFFFF Gui, MyGui: Font, S18 C...
by Marcosa1020
11 Jan 2018, 08:43
Forum: Ask For Help
Topic: The window change
Replies: 4
Views: 977

Re: The window change

TheDewd wrote:Trying adding Gui, MyGui: Destroy:

Code: Select all

F3::
Gui, Submit, NoHide										
GuiControl, Font, MyEdit		
Gui, MyGui: +AlwaysOnTop
Gui, MyGui: Font, S10 C000000 , Tahoma
WinGetPos, x,y,w,h, Window_C
WinClose, Program_A
WinClose, Program_B
Gui, MyGui: Destroy
Hi,
Thanks a lot.
by Marcosa1020
11 Jan 2018, 08:13
Forum: Ask For Help
Topic: The window change
Replies: 4
Views: 977

The window change

Hi, Please see my script. If the DropDownList is "A", and then press the F3, program_A window will be displayed. When the DropDownList is "B", and then press the F3, program_A window will be displayed, I don't understand why not display program_B window ? Thank you. #NoTrayIcon Gui, Show, x300 y100 ...
by Marcosa1020
05 Jan 2018, 08:00
Forum: Ask For Help
Topic: How to simplify Gui ? Topic is solved
Replies: 8
Views: 1715

Re: How to simplify Gui ? Topic is solved

Gui, MyGUI:New ; creates a new window and sets it as the default for the current thread (that is, the name of the GUI can be omitted if all subsequent commands operate only upon this specific GUI) ypos := [ 311, 300, 289, 278, 268, 257, 246, 235, 224, 213, 202, 191 ] Loop, % ypos.length() ; each ar...
by Marcosa1020
05 Jan 2018, 06:33
Forum: Ask For Help
Topic: How to simplify Gui ? Topic is solved
Replies: 8
Views: 1715

Re: How to simplify Gui ? Topic is solved

Hi Marcosa1020 , Try the following instead: Gui, MyGUI:New ; creates a new window and sets it as the default for the current thread (that is, the name of the GUI can be omitted if all subsequent commands operate only upon this specific GUI) ypos := [ 311, 300, 289, 278, 268, 257, 246, 235, 224, 213...
by Marcosa1020
04 Jan 2018, 11:31
Forum: Ask For Help
Topic: How to simplify Gui ? Topic is solved
Replies: 8
Views: 1715

Re: How to simplify Gui ? Topic is solved

NumOfText = 10 ypos = 181 Loop, % NumOfText { Gui, Add, Text, y%ypos% x22 C000000, A Gui, Add, Text, y%Ypos% x28 C000000, B ypos += 10 } Gui, Show, w500 h600, MyGui esc:: GuiClose: ExitApp Hi, I tried to change ypos code and got it an error, could you help me ? Thanks. NumOfText = 12 ypos:=[311,300...
by Marcosa1020
04 Jan 2018, 11:24
Forum: Ask For Help
Topic: How to simplify Gui ? Topic is solved
Replies: 8
Views: 1715

Re: How to simplify Gui ? Topic is solved

Hi, Could you tell me how can I to simplify Gui ? They are so lengthy.... Thanks. Gui, MyGui:Font, S7, Tahoma Gui, MyGui:Add, Text, x22 y311 C000000, A Gui, MyGui:Add, Text, x22 y300 C000000, A Gui, MyGui:Add, Text, x22 y289 C000000, A Gui, MyGui:Add, Text, x22 y278 C000000, A Gui, MyGui:Add, Text,...
by Marcosa1020
04 Jan 2018, 07:59
Forum: Ask For Help
Topic: How to simplify Gui ? Topic is solved
Replies: 8
Views: 1715

How to simplify Gui ? Topic is solved

Hi, Could you tell me how can I to simplify Gui ? They are so lengthy.... Thanks. Gui, MyGui:Font, S7, Tahoma Gui, MyGui:Add, Text, x22 y311 C000000, A Gui, MyGui:Add, Text, x22 y300 C000000, A Gui, MyGui:Add, Text, x22 y289 C000000, A Gui, MyGui:Add, Text, x22 y278 C000000, A Gui, MyGui:Add, Text, ...
by Marcosa1020
03 Jan 2018, 08:08
Forum: Ask For Help
Topic: The window
Replies: 4
Views: 955

Re: The window

Since is not clear what you want to achieve ( what about window_A ? ), this is a simple way for showing a window relatively to another window. Hope this helps. Cheers Gui +AlwaysOnTop Gui, Show, x400 y300 h400 w400,Window_C WinGetPos, x,y,w,h, Window_C Gui, MyGui: +AlwaysOnTop Gui, MyGui:Show,% "x"...
by Marcosa1020
02 Jan 2018, 07:07
Forum: Ask For Help
Topic: The window
Replies: 4
Views: 955

Re: The window

Yes, BoBo.
Thank you so much.
By the way, do you know how can I make window_B open on window_C's x35 y150 position?

Go to advanced search