How to Open Excel from Access Using VBA

31-August-2021
Sometimes it is very useful to be able to open an Excel sheet and work on it programmatically, as if you were opening it in Excel manually. This can certainly be done using VBA, and in this episode I’ll show you how to open an Excel sheet for reading, as well as for writing and updates. The ease of how you can do this is one of the great strengths of Microsoft Office. Let’s go open Excel using Access VBA!



MS Access Project? Contact me today!