Search found 1414 matches

by TheDewd
09 Oct 2020, 14:21
Forum: Ask For Help
Topic: Excel Conditional Formatting
Replies: 4
Views: 170

Excel Conditional Formatting

I can't figure out how to convert this Excel macro to AutoHotkey COM Object code. Home > Conditional Formatting > Highlight Cell Rules > Text That Contains... > Format cells that contain the text "PASS" with "Green Fill with Dark Green Text". I want to add the condition to a specific column where th...
by TheDewd
09 Oct 2020, 08:17
Forum: Ask For Help
Topic: Excel Workbook Copy To Topic is solved
Replies: 10
Views: 225

Re: Excel Workbook Copy To Topic is solved

I examined everyone's code and found what works best for my purpose. Thank you, everyone! Let me know if you see any mistakes. :thumbup: #SingleInstance, Force File := [] File[1] := A_ScriptDir "\MyFile1.csv" File[2] := A_ScriptDir "\MyFile2.csv" File[3] := A_ScriptDir "\MyFile3.csv" File[4] := A_Sc...
by TheDewd
08 Oct 2020, 19:58
Forum: Ask For Help
Topic: Excel Workbook Copy To Topic is solved
Replies: 10
Views: 225

Re: Excel Workbook Copy To Topic is solved

@FanaticGuru
Thank you! Your code also works. I'll study each example provided. Thank you everyone!!! :wave:
by TheDewd
08 Oct 2020, 19:45
Forum: Ask For Help
Topic: Excel Workbook Copy To Topic is solved
Replies: 10
Views: 225

Re: Excel Workbook Copy To Topic is solved

I'm not sure if this code is comletely correct, but for me it works. Your code seems to work with my data too. Thank you! I would have thought there was a simpler way, like copying worksheets from existing Workbooks, etc. If no one comes along with a more simple solution, this will definitely be wh...
by TheDewd
08 Oct 2020, 19:39
Forum: Ask For Help
Topic: Excel Workbook Copy To Topic is solved
Replies: 10
Views: 225

Re: Excel Workbook Copy To Topic is solved

Post your code. I have the following in my script which opens two CSV files in Excel. I'm trying to figure out still how to copy all of the files into one Workbook on separate Worksheet tabs. Using the Macro editor to see VBA commands to Copy, however by opening both files using AutoHotkey, the "Mo...
by TheDewd
08 Oct 2020, 18:39
Forum: Ask For Help
Topic: Excel Workbook Copy To Topic is solved
Replies: 10
Views: 225

Excel Workbook Copy To Topic is solved

I have a few different CSV files I want to merge into a single Excel Workbook, with the contents of each CSV file on a separate WorkSheet.

Any ideas?
by TheDewd
17 Sep 2020, 15:16
Forum: Other Utilities & Resources
Topic: WSConfig [CMD]
Replies: 2
Views: 127

Re: WSConfig [CMD]

Nice! Took me a minute to find the link in your post. ;-)
by TheDewd
17 Sep 2020, 14:00
Forum: Ask For Help
Topic: perform Google search for a highlighted term on a specific website Topic is solved
Replies: 3
Views: 217

Re: perform Google search for a highlighted term on a specific website Topic is solved

Code: Select all

#SingleInstance, Force

!g::
	ClipBak := Clipboard
	Clipboard := ""
	Send, ^c
	ClipWait
	Run, % "https://www.google.com/search?q=" Clipboard "+site%3Aec.europa.eu"
	Sleep, 200
	Clipboard := ClipBak
return
by TheDewd
17 Sep 2020, 10:35
Forum: Ask For Help
Topic: Send random txt message from a .txt file when i press a key Topic is solved
Replies: 5
Views: 97

Re: Send random txt message from a .txt file when i press a key Topic is solved

Non-repeating random, from text file: #SingleInstance, Force ; Allow only one running instance of script ; Generate text file if not already existing If !(FileExist("TextList.txt")) { File := FileOpen("TextList.txt", "w") File.WriteLine("Text001") File.WriteLine("Text002") File.WriteLine("Text003") ...
by TheDewd
17 Sep 2020, 09:43
Forum: Ask For Help
Topic: Send random txt message from a .txt file when i press a key Topic is solved
Replies: 5
Views: 97

Re: Send random txt message from a .txt file when i press a key Topic is solved

Something like this will work... You could make random more advanced, not showing values that have already been shown until all available choices have been used, etc... #SingleInstance, Force TextList = ( Text001 Text002 Text003 Text004 Text005 Text006 Text007 Text008 Text009 Text010 ) StringReplace...
by TheDewd
17 Sep 2020, 08:53
Forum: Ask For Help
Topic: Obtain information from html Topic is solved
Replies: 8
Views: 256

Re: Obtain information in javascript Topic is solved

This is HTML, not JavaScript. #SingleInstance, Force HTML = ( <html> <head> <title>xyzxyzxyzxyz</title> <meta http-equiv="Content-Type" content="text/html; charset=GBK"> <link rel="stylesheet" href="/aic/skins/1//style.css" type="text/css"> </head> <body> <table cellspacing=0 cellpadding=0 width="75...
by TheDewd
09 Sep 2020, 12:44
Forum: Other Utilities & Resources
Topic: Windows 10 Ameliorated !??
Replies: 2
Views: 631

Re: Windows 10 Ameliorated !??

Just learned about this a few days ago from a YouTube video by Linus Tech Tips: https://www.youtube.com/watch?v=nwkiU6GG-YU
by TheDewd
31 Aug 2020, 12:30
Forum: Ask For Help
Topic: How do I: Pass a button label as a variable?
Replies: 3
Views: 110

Re: How do I: Pass a button label as a variable?

Code: Select all

Msgbox, % A_GuiControl
by TheDewd
26 Aug 2020, 10:12
Forum: Ask For Help
Topic: How can I make this "<" key to act as Left Shift? Topic is solved
Replies: 3
Views: 66

Re: How can I make this "<" key to act as Left Shift? Topic is solved

,::LShift

Use comma. The "<" key is only active while shift is being pressed. In your case, you will need to use comma, which is the active key when the shift-modifier is not used.
by TheDewd
24 Aug 2020, 10:25
Forum: Scripts and Functions
Topic: [Library] Neutron.ahk - AutoHotkey Web GUIs on Steroids
Replies: 52
Views: 11145

Re: [Library] Neutron.ahk - AutoHotkey Web GUIs on Steroids

IE would be required to my knowledge. And I'm not sure how easy it is to completely uninstall IE. Doing some quick searching it seems like IE11 is considered a "feature" of the OS and must be removed in a different way than just uninstalling a program. Great! So, another thing I thought of... If th...
by TheDewd
24 Aug 2020, 10:16
Forum: Scripts and Functions
Topic: [Library] Neutron.ahk - AutoHotkey Web GUIs on Steroids
Replies: 52
Views: 11145

Re: [Library] Neutron.ahk - AutoHotkey Web GUIs on Steroids

Question: If a user has completely removed Internet Explorer from their PC, will this still work?

I understand that the engine is used in Internet Explorer, but is this completely independent from that meaning it will still function without IE installed?

Thanks!
by TheDewd
05 Aug 2020, 14:52
Forum: Ask For Help
Topic: Parse passwords from line of text - multiple hits - regex Topic is solved
Replies: 3
Views: 1285

Re: Parse passwords from line of text - multiple hits - regex Topic is solved

#SingleInstance, Force String = "   </span><span>data-tid="foundPassword">password1</span></span></span>   </span><span class="globalReport_infoStringAlongPassword">>   </span><span>data-tid="foundPassword">password2</span>" Pos := 0 While (Pos := RegExM...
by TheDewd
30 Jul 2020, 12:05
Forum: Ask For Help
Topic: Any way to send commands (not keystrokes) to Excel?
Replies: 4
Views: 1921

Re: Any way to send commands (not keystrokes) to Excel?

The link I provided has a "Hello World" example.

Like this:

Code: Select all

Alt & Right::
	XL := ComObjActive("Excel.Application")
	Xl.Range("A1").Value := "hello world!"
return
Is there something more specific we could write for you to help you with your task?
by TheDewd
29 Jul 2020, 11:01
Forum: Ask For Help
Topic: Need Help Getting Values from XML Text Topic is solved
Replies: 12
Views: 2746

Re: Need Help Getting Values from XML Text Topic is solved

This is janky but gets the job done. colt , I don't think the actual XML data will contain the bold tags. This is just the attempted formatting he tried for this post, but when applying the code tag in a post if will ignore the formatting and just show " [ b ] " and " [ /b ] " instead of actually m...

Go to advanced search