r/AutoHotkey•
cippalippa00

Wildcard in Excel file name

!c:: 

{	
	
ClipSaved := ClipboardAll	 

Clipboard =	 

Send, ^c		

ClipWait	

xl := ComObjActive("Excel.Application")

xl.WorkBooks("excelfileXYZ.xlsx").Activate
	
winactivate, ahk_class XLMAIN

Xl.Selection.Value := Clipboard 	

Clipboard := ClipSaved		

}	

return	

Hi, i need some help with this code: i need to replace the name of the excel file that will be activated with a wildcard. Instead of "excelfileXYZ.xlsx", i need "excelfileABC.xlsx" or "excelfileHHH.xlsx" or "excelfileQWER.xlsx", ecc... How can i achieve that?

Posted Jun 4, 2019, 3:09 PM UTC

13
Loading comments…