Category: VBA

The FileDateTime function in VBA is used to return the date and time when a file was created or last modified. This function takes a single argument, which is the path to the file

The FileLen function in VBA (Visual Basic for Applications) is used to get the size of a file in bytes. Before you use it, make sure that the file exists because if the file is not found, the function will trigger a runtime error

The Error function in VBA, sometimes confused with the Err object, isn’t directly relevant to error handling. Instead, the Error function is used to return the error message that corresponds to a given error number

In VBA (Visual Basic for Applications), the FileAttr function is used to return the file mode for files opened with the Open statement. It’s important to note that this function is not commonly used and is considered a legacy function; in modern VBA, you’d typically use the higher-level file handling objects like Scripting.FileSystemObject

The Environ function in VBA allows you to get the value of an environment variable from the operating system. Environment variables contain information about the system environment, such as the user’s name, the system directory, and the path to temporary files

In VBA (Visual Basic for Applications), the EOF function is used to determine if the end of a file opened for Input or Binary mode has been reached. EOF stands for End Of File. The EOF function returns True when there are no more data to be read from a file, and False otherwise. It is typically used in a loop to continue reading data until the end of a file is encountered

DoEvents in Visual Basic for Applications (VBA) is a function that allows the operating system to process other events, such as user interactions, messages from other applications, or updates to the user interface, while a procedure is running. This can be especially useful in long-running loops or operations that might make the application seem unresponsive

The DDB (Double Declining Balance) function is part of the Financial functions category in Excel VBA. It calculates the depreciation of an asset for a specified period using the Double-Declining Balance Method or some other method you specify

The Dir function in VBA (Visual Basic for Applications) is used to return the name of a file, directory, or folder that matches a specified pattern or attributes. It is often used to loop through files or folders in a directory. The function can return one file name at a time, and it must be called repeatedly to get additional file names

The Day function in VBA (Visual Basic for Applications) is used to obtain the day part of a given date. It returns an integer value representing the day of the month from 1 to 31