Another way to remove VBA project password is; Open xls file with a hex editor. (ie. Hex Edit http://www.hexedit.com/) Search for DPB Replace DPB to DPx Save file. Open file in Excel. Click “Yes” if you get any message box. Set new password from VBA Project Properties. Close and open again file, then type your … Read more
Go with a triple negative: If (Not Not FileNamesList) <> 0 Then ‘ Array has been initialized, so you’re good to go. Else ‘ Array has NOT been initialized End If Or just: If (Not FileNamesList) = -1 Then ‘ Array has NOT been initialized Else ‘ Array has been initialized, so you’re good to … Read more
I have never heard of an alternative IDE for Vb6. However, these two (free) VB6 add-ins are indispensable and will make your life easier – especially if there is a lot of code. They are equally effective for VBA in Microsoft Office. MZ-Tools: provides a superb collection of IDE tools – finding unused variables, unused … Read more
I found the answer on the web: Dim fsT As Object Set fsT = CreateObject(“ADODB.Stream”) fsT.Type = 2 ‘Specify stream type – we want To save text/string data. fsT.Charset = “utf-8” ‘Specify charset For the source text data. fsT.Open ‘Open the stream And write binary data To the object fsT.WriteText “special characters: äöüß” fsT.SaveToFile sFileName, … Read more
.NET has spoiled us 🙂 Your declaration is not valid for VBA. Only constants can be given a value upon application load. You declare them like so: Public Const APOSTROPHE_KEYCODE = 222 Here’s a sample declaration from one of my vba projects: If you’re looking for something where you declare a public variable and then … Read more
Try using Worksheet.Protect “Password”, UserInterfaceOnly := True If the UserInterfaceOnly parameter is set to true, VBA code can modify protected cells.
The best you can do is bend the office Visual Basic Editor (VBE) tool to your liking. If you stay in it’s native environment you get the full power of error detection, Intellisense, live code running, etc. My tips… In the VBE go to Tools > Options > Editor tab. Turn off ‘Auto Syntax Check’. … Read more
Isn’t it good enough? Public Function Contains(col As Collection, key As Variant) As Boolean Dim obj As Variant On Error GoTo err Contains = True obj = col(key) Exit Function err: Contains = False End Function
You can use a GoTo: Do ‘… do stuff your loop will be doing ‘ skip to the end of the loop if necessary: If <condition-to-go-to-next-iteration> Then GoTo ContinueLoop ‘… do other stuff if the condition is not met ContinueLoop: Loop
Dim and Private work the same, though the common convention is to use Private at the module level, and Dim at the Sub/Function level. Public and Global are nearly identical in their function, however Global can only be used in standard modules, whereas Public can be used in all contexts (modules, classes, controls, forms etc.) … Read more