What do you want to save?
Add Code snippet
New code examples in category VBA
-
Bitemyapp 2021-09-14 03:07:01
excel vba Imitating the "IN" operator from python
'VBA does not have an IN operator, but we can do this: Function IsIn(a, b) As Boolean IsIn = InStr("," & b & ",", "," & a & ",") End Function '--------------------------------------------------... Add solution -
Artesian 2021-09-14 00:17:02
vbs run
Set oShell = CreateObject("WScript.Shell") ' Run the command dir in a hidden window without waiting for it to finish oShell.Run "dir", 0, false ' Run the command dir in a visible window and wait for it to finish oShell.Run "dir&... Add solution -
Kenster 2021-09-13 22:42:02
vba like
'VBA's Like operator can be used to determine if 'one string is contained in another: MsgBox "Excel Hero" Like "*Hero" 'Displays: True 'Notice that 'Find' supports wild card characters. 'Full documentation: ' https://docs.micro... Add solution -
Dee M 2021-09-13 07:56:03
excel vba urlmon
Private Declare PtrSafe Function URLDownloadToFile Lib "urlmon" _ Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, _ ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long Add solution
Best helpers
Ranking is empty