Listing and selecting time zones in Microsoft Access and Excel is not straight forward. In the previous article was shown how to retrieve the time zones of Windows. Here will be demonstrated how to create tables to store these and how to display and…
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…