Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can launch Excel, create workbooks, and then programmatically manipulate those workbooks.
1. Create a reference to the Excel application object.
2. Write code that launches Excel, makes it visible, creates a workbook, and sets the value of cell A1 to "Hello World".
3. Run the code and watch it execute.
4. Explain that other commands can be used to programmatically control Excel.
Do you need a date time picker, how about just a time picker? Would you like to use something other than the basic Access date picker which is available when you have a textbox which contains data formatted as a date? Give this date time picker a t…
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…