What do you want to save?
Add Code snippet
New code examples
-
-
VBA 2021-11-15 18:35:19
excel vba count instances of substring
'VBA functions to count the occurrnces of a substring in a string. 'Choose your function flavor: 'Small and Slow: Function InStrCount&(s1$, s2$, Optional Compare As VbCompareMethod = vbBinaryCompare) If Len(s1) Then If Len(s2) Then InStrCount = ... Add solution -
VBA 2021-11-07 07:20:16
excel vba get list of Excel files in a folder
'VBA function to return an array of file names from a folder: Public Function GetFiles(sPath$, Optional sFilter$ = "*.*") Dim p&, f$, s$: s = Space(1e6) f = Dir(sPath & _ String(Abs(Right(sPath, 1) <> "... Add solution -
-
VBA 2021-10-02 01:04:02
excel vba count substring in string
'VBA functions to count the occurrnces of a substring in a string. 'Choose your function flavor: 'Small and Slow: Function InStrCount&(s1$, s2$, Optional Compare As VbCompareMethod = vbBinaryCompare) If Len(s1) Then If Len(s2) Then InStrCount = ... Add solution -
Other 2021-09-29 06:24:02
vbscript to winzip a file with password
strWinZipDir = "C:\Program Files\WinZip\WINZIP64.exe" strZipFileToCreate = LocalPath & "FileName.zip" strFilesToZip = LocalPath & "*.txt" Set objFSO = CreateObject("Scripting.FileSystemObject") strWinZip ... Add solution