What do you want to save?
Add Code snippet
New code examples in category VBA
-
Awgiedawgie
2022-03-27 20:55:02
excel vba check if all substrings in list are in string
'VBA function to check if ALL of a list of substrings is contained 'within a string: Function AllIn(s$, ParamArray checks()) As Boolean Dim e For Each e In checks If 0 = InStrB(s, e) Then Exit Function Next AllIn = True End Functi... Add solution -
Krish
2022-03-27 20:40:39
excel vba set cell value to empty
Range("A1:D5").ClearContents Add solution -
-
Awgiedawgie
2022-03-27 09:10:09
excel vba string to bits
'VBA function to convert text to a binary string representation: Public Function TextToBinaryString$(s$) Dim c&, i&, lo&, bin$(0 To 255), d() As Byte Const ZEROS$ = "00000000" For c = 0 To 255 bin(c) = ZEROS ... Add solution -
Phoenix Logan
2022-03-24 12:20:06
Excel web scraping
Sub test() Dim ie As New InternetExplorer Dim doc As New HTMLDocument Dim ecoll As Object ie.Visible = True ie.navigate "http://demo.guru99.com/test/web-table-element.php" Do DoEvents Loop Until ie.readyState = READYSTATE_COMPLETE Set doc = ie.... Add solution -
A-312
2022-03-21 18:00:05
excel vba save file txt
' Needs to add "Microsoft Scripting Runtime" reference to your file Public Sub SaveTextToFile(ByVal pFile As String, ByVal pText As String) Dim fso As FileSystemObject Dim fileStream As TextStream Set fso = New FileSystemObject ... Add solution
Best helpers
Ranking is empty
