Code: Select all
str := "blahblahblah=YYMMblahblahblah"
msgbox year := substr(str,instr(str,"=")+1,2)
msgbox month := substr(str,instr(str,"=")+3,2)
Code: Select all
str := "blahblahblah=YYMMblahblahblah"
msgbox year := substr(str,instr(str,"=")+1,2)
msgbox month := substr(str,instr(str,"=")+3,2)
Code: Select all
#+c::
{
a_clipboard := ""
send "^c"
if clipwait(1)
{
z := regexreplace(a_clipboard,"`n`r","`n")
arr := strsplit(z,"`n`n","`r")
MsgBox(a:=arr[1] b:=arr[2])
}
}
Code: Select all
str := '%B1111222233334444^LastName/FirstName'
MsgBox LName := StrSplit(str,['^','/'])[2]
Code: Select all
xl := ComObjActive("excel.application")
xl.activeWorkbook.SaveCopyAs("E:\" xl.activeWorkbook.name) ; E:\ or whatever path
xl.activeWorkbook.close(1) ; close(1) saves under current path\name then closes