Launch Excel Macros with MS Access
33rd Lesson
In this episode we will discover two different ways to launch Excel Macros with MS Access, one will be completely internal to Access the other, a little more powerful, will launch Excel macros relying on a vbscript file.
=========== S O S T I E N I M I ==================
Subscribe to this channel to access the benefits: / @lodovicodincau
Buy a product: https://lodovicodincau.myspreadshop.it/
Donate: https://www.paypal.com/donate/?cmd=_d...
======= SAFE AND AFFORDABLE SOFTWARE! ==
Office, Windows, Antivirus, VPN, Server: https://mrkeyshop.com/it/?MrKey=484
======= MY EQUIPMENT ===============
Mouse: https://amzn.to/3s1XwF2
Yeti microphone: https://amzn.to/3MDCggU
Microphone without stand: https://amzn.to/3LAoWcS
Yeti filter: https://amzn.to/3KwKAO2
Sony Alpha 6400L: https://amzn.to/3t5cN8u
Elgato Stream Deck: https://amzn.to/3NDf0RM
Elgato Cam Link 4K: https://amzn.to/3NHXtIb
Elgato Facecam: https://amzn.to/3F1Cagk
TC Helicon Mixer: https://amzn.to/3TbTmoZ
RGB keyboard: https://amzn.to/3MGytiL
2k Gaming monitors: https://amzn.to/3vYb7OP
Switch: https://amzn.to/372aYl8
Microsoft 365 Family: https://amzn.to/38H85qc
Microsoft 365 Business: https://amzn.to/3OSDQO2
My name is Excel - troubleshooting: https://amzn.to/3vVBPb1
The Definitive Guide to DAX: https://amzn.to/376c7s2
Prime Student 90 days free: https://amzn.to/3MJ8LKw
============ R I S O R S E ====================
DOWNLOAD for "Student Plus" or higher: https://drive.google.com/file/d/1ZWu-...
Channel index - Available to subscribers only: https://docs.google.com/spreadsheets/...
Lesson Chapters:
1. Introduction 0:00
2. Activating the Excel Library 1:37
3. Let's read the standard function code 2:16
4. Let's see the basic function in VBS 7:22
5. Let's look at the "base" VBS script 10:24
6. Let's see the advanced function in VBS 12:33
7. Let's look at the "advanced" VBS script 14:51
8. Open PW protected files for writing 18:55
9. Greetings 7:53pm
#MacroExcel #MacroAccess #VbScript