VBA

It is normal to create temporary files and folders to facilitate the process in programs. Apart from doing it in your working directory, why …

Do you ever find it hard to get the millisecond in your programs? In default VBA does not provide this function, however we …

Normally, we need to go through bunch of clicks to do one action in MS Access. For example, “Compact and Repair Database”. This function …

We can use shell to execute any programs. Please be reminded that we may need to execute in an indirect way. To …

To prevent your program from not responding in VBA, add DoEvents to anywhere you might have a lot of data to process. …

We can easy resize the array declared in VBA. The trick is actually relocate the array to a bigger space. Suppose we …