JoeGlines

*///////////////. DEFINE !DDN (DupVar !TOKENS (1)) SORT CASES BY !DupVar (A) . MATCH FILES /FILE = * /BY !DupVar /FIRST = First. var label first "Unique and Duplicates". value label first 0'Duplicates' 1'Unique'. Freq First /FORMAT=DVALUE. select if First=1. match files file= * / drop First. exe. !ENDDEFINE. *///////////////. /* !DDN DupVar=Number. *////SPSS macro to remove duplicates on String variable///////////. DEFINE !DDA (DupVar !TOKENS (1)) String duh (A1000). SORT CASES BY !DupVar (A) . compute duh=Lowcase(!DupVar). MATCH FILES /FILE = * /BY Duh /FIRST = First. var label first "Unique and Duplicates". value label first 0'Duplicates' 1'Unique'. Freq First /FORMAT=DVALUE. select if First=1. match files file= * / drop First duh. exe. !ENDDEFINE. *///////////////. /* !DDA DupVar=email. *///////////////. DEFINE !DDM (Var1 !TOKENS (1) / Var2 !Tokens (1) ) String duh1 duh2 (A1000). Compute duh1=Lowcase(!Var1). Compute duh2=Lowcase(!Var2). SORT CASES BY Duh1 (A) Duh2 (A). MATCH FILES /FILE = * /BY Duh1 Duh2 /

JoeGlines

; Want a clear path for learning AutoHotkey? Go to https://the-Automator.com/Learn
; https://www.autohotkey.com/docs/v2/lib/_HotIf.htm
#SingleInstance
#Requires Autohotkey v2.0+

#HotIf MouseIsOver("ahk_class Shell_TrayWnd")
WheelUp::Send "{Volume_Up}"
WheelDown::Send "{Volume_Down}"

MouseIsOver(WinTitle) {

JoeGlines

;~ ~AppsKey & h::Run Excel.exe C:\Users\Joe\Dropbox\diet.xlsx ;diet

JoeGlines

;*******************************************************
; Want a clear path for learning AutoHotkey; Take a look at our AutoHotkey courses.  
;They're structured in a way to make learning AHK EASY:  https://the-Automator.com/Learn
;*******************************************************
;~ #Include <default_Settings> 
#Requires AutoHotkey v1.1.33+
;**************************************
#SingleInstance force
#Requires AutoHotkey v1.1.36+ ; prefer 64-Bit

JoeGlines

;*******************************************************
; Want a clear path for Discovering AutoHotkey; Take a look at our AutoHotkey courses.  
;They"re structured in a way to make learning AHK EASY:  https://the-Automator.com/Discover
;*******************************************************
#Include <default_Settings> 
#Requires AutoHotkey v1.1.33+
;**************************************
runApp("Paint") ;this calls the below function and will launch the named app
runApp("WordPad") ;this calls the below function and will launch the named app
return

JoeGlines

;*******************************************************
; Want a clear path for learning AutoHotkey; Take a look at our AutoHotkey courses.  
;They"re structured in a way to make learning AHK EASY:  https://the-Automator.com/Discover
;*******************************************************
#SingleInstance
#Requires Autohotkey v2.0+

runApp('Spotify') ;this will launch Spotify

runApp(appName) { ; https://www.autohotkey.com/boards/viewtopic.php?p=438517#p438517

JoeGlines

#HotIf WinActive(' - Excel ahk_class XLMAIN')
F1:: ; Load Data
{
	Global Data
	PXL := XL_Start_Get() ; will connect to active Excel / Start new Workbook if no XL application
	; Range := XL_Get_Selected_Range(PXL,1) ; Get selected range (set absolute to 1 if you want $)
	

JoeGlines

#Requires AutoHotkey v1.1.33+
Clipboard:="11231	Josh	11-11-2023	Manager"
Clipboard:=StrReplace(Clipboard,"`t","`r`n")
send ^v

JoeGlines

if !ClipWait(2)
{
    Notify.Default.GenSound := "Error"
    Notify.show('The attempt to copy text onto the clipboard failed.')
    sleep 3000
    Exitapp
}

JoeGlines

/*
 * ============================================================================ *
 * Want a clear path for learning AutoHotkey?                                   *
 * Take a look at our AutoHotkey courses here: the-Automator.com/Learn          *
 * They're structured in a way to make learning AHK EASY                        *
 * And come with a 200% moneyback guarantee so you have NOTHING to risk!        *
 * ============================================================================ *
*/

#SingleInstance