Search found 125 matches

by Marcosa1020
17 Mar 2019, 09:31
Forum: Ask For Help
Topic: How can I get the barcode ?
Replies: 6
Views: 621

Re: How can I get the barcode ?

Gui +AlwaysOnTop Gui, Font, S10 c000000 , Tahoma Gui, Add, text, x20 y25, A Gui, Add, Edit, x50 y20 w92 h28 gwritecardB vcardA Gui, Add, text, x20 y75, B Gui, Font, S24 c000000 , Free 3 of 9 Extended Gui, Add, Edit, x50 y70 w92 h28 vcardB Gui, Show, x131 y91 h155 w188,Barcode return writecardB: gui...
by Marcosa1020
17 Mar 2019, 08:42
Forum: Ask For Help
Topic: How can I get the barcode ?
Replies: 6
Views: 621

Re: How can I get the barcode ?

How do I enter 12345 on cardA after, cardB also shows 12345 ???
by Marcosa1020
17 Mar 2019, 06:27
Forum: Ask For Help
Topic: How can I get the barcode ?
Replies: 6
Views: 621

Re: How can I get the barcode ?

Hi Kobaltauge, Thank you for your reply. Yes, I have a font installed. Hi Ahk_fan, Thank you for your reply. I can only use AHK source code and no network. Can you tell me how to associate column A with column B when I enter text or number in column A. If A column is equal to B column, then I change...
by Marcosa1020
17 Mar 2019, 04:22
Forum: Ask For Help
Topic: How can I get the barcode ?
Replies: 6
Views: 621

How can I get the barcode ?

Hello, When I into the number to column A, how can I get the barcode 12345 from column B ? If I don't have font "3 of 9 extended" in my computer. Can I also get the barcode? Thanks. Gui +AlwaysOnTop Gui, Font, S10 C000000 , Tahoma Gui, Show, x131 y91 h155 w188,Barcode Gui, Font, S10 c000000 , Tahoma...
by Marcosa1020
20 Jan 2019, 07:53
Forum: Ask For Help
Topic: Find keywords and fill in strings.... Topic is solved
Replies: 12
Views: 1286

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

Hi, Thanks a lot for coffee and IMEime, they helped me to complete the script. :thumbup: #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 h...
by Marcosa1020
20 Jan 2019, 00:37
Forum: Ask For Help
Topic: Find keywords and fill in strings.... Topic is solved
Replies: 12
Views: 1286

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: 1286

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: 1286

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: 1286

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: 1286

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: 1286

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: 1286

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: 1069

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: 1069

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: 1069

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: 660

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: 660

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: 660

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: 1116

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: 1116

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

Go to advanced search