Connect to MS Access with Password via VBA
My users have a MS Access database with password. I was asked to write a
macro in Excel to connect to MS Access, extract the data based on a certain
criteria. Put in Excel workbook and email to a recipient automatically. Is it
doable?
Can you help me with the code.
Thanks
Matelot
|