I think you are looking for the Dictionary object, found in the Microsoft Scripting Runtime library. (Add a reference to your project from the Tools…References menu in the VBE.) It pretty much works with any simple value that can fit in a variant (Keys can’t be arrays, and trying to make them objects doesn’t make … Read more
VBA does not have a Continue or any other equivalent keyword to immediately jump to the next loop iteration. I would suggest a judicious use of Goto as a workaround, especially if this is just a contrived example and your real code is more complicated: For i = LBound(Schedule, 1) To UBound(Schedule, 1) If (Schedule(i, … Read more
1.) Check here. Basically do this: Function FileExists(ByVal FileToTest As String) As Boolean FileExists = (Dir(FileToTest) <> “”) End Function I’ll leave it to you to figure out the various error handling needed but these are among the error handling things I’d be considering: Check for an empty string being passed. Check for a string … Read more
Use FSO to create the file and write to it. Dim fso as Object Set fso = CreateObject(“Scripting.FileSystemObject”) Dim oFile as Object Set oFile = FSO.CreateTextFile(strPath) oFile.WriteLine “test” oFile.Close Set fso = Nothing Set oFile = Nothing See the documentation here: http://technet.microsoft.com/en-us/library/ee198742.aspx http://technet.microsoft.com/en-us/library/ee198716.aspx
Do the following in your VBA editor window (entitled “Microsoft Visual Basic for Applications”): Click the menu “Tools” and then “Options“. In the Options’ “Editor” tab, uncheck the “Auto Syntax Check” box. (See screenshot, below.) This change does not make the editor stop compiling in the background and marking syntax errors in red (or whatever … Read more
set is used to assign a reference to an object. The C equivalent would be int i; int* ref_i; i = 4; // Assigning a value (in VBA: i = 4) ref_i = &i; //assigning a reference (in VBA: set ref_i = i)
CStr(45) is all you need (the Convert String function)
There is no shorthand in VBA unfortunately, The closest you will get is a purely visual thing using the : continuation character if you want it on one line for readability; Dim clientToTest As String: clientToTest = clientsToTest(i) Dim clientString As Variant: clientString = Split(clientToTest) Hint (summary of other answers/comments): Works with objects too (Excel … Read more
For nearly all programming purposes, VBA and VB 6.0 are the same thing. VBA cannot compile your program into an executable binary. You’ll always need the host (a Word file and MS Word, for example) to contain and execute your project. You’ll also not be able to create COM DLLs with VBA. Apart from that, … Read more
Dir takes wild cards so you could make a big difference adding the filter for test up front and avoiding testing each file Sub LoopThroughFiles() Dim StrFile As String StrFile = Dir(“c:\testfolder\*test*”) Do While Len(StrFile) > 0 Debug.Print StrFile StrFile = Dir Loop End Sub