What do you want to save?
Add Code snippet
New code examples in category VBA
-
Krish 2022-03-15 12:30:47
excelvba large hexadecimal string to decimal
'VBA function to convert a hexadecimal string into a decimal. Uses 'the Decimal Variant subtype to allow for much larger values than the 'worksheet function HEX2DEC() or CLng("&h" & HexVal) can achieve. It 'returns an UNSIGNED Decimal i... Add solution -
Phoenix Logan 2022-03-15 05:15:29
vba should i use .value .value2
'Go with: Range.Value2 '<------Best way 'It is almost always the best choice to read from or 'write to an Excel cell or a range... from VBA. 'Each of the following can be used to read from a range: v = [a1] v = [a1].Value v = [a1].Value2 v = [a1].Tex... Add solution -
Awgiedawgie 2022-03-11 22:50:03
vba mod function floating point number
'VBA does have the 'Mod' operator: MsgBox 5 Mod 2 '<--displays: 1 (5 ÷ 2 has a REMAINDER of 1) 'But bear in mind that it returns an integer value... always. MsgBox 11.5 Mod 3 '<--displays: 0 (But it should be 2.5) 'And in... Add solution -
Awgiedawgie 2022-03-09 21:40:03
excel vba saveas force overwrite
Set xls = CreateObject("Excel.Application") xls.DisplayAlerts = False Set wb = xls.Workbooks.Add fullFilePath = importFolderPath & "\" & "MyFile.xlsx" wb.SaveAs fullFilePath, AccessMode:=xlExclusive, _ Conflict... Add solution
Best helpers
3demax
+5
Xoxocrow
+5
ZXX
+5
ThatsNinja
+5
Wai Yan
+5
Rabbid
+5
416E64726577
+5
Answerplease
+5
Giammin
+5
John Lapham
+5
L Marsh
+5
Dcw
+5
Elsa P.
+5
Ages
+5
Riptiki
+5