Open a password protected excel workbook from second workbook to fetch data using dynamic connection
Hi,
I have two excel applications. I wish to fetch data from excel application A
to excel application B using recordsets. My excel application A is password
protected. How do I fetch the data without actually opening application A
(using recordsets in excel application B).
Any help is most welcome.
Thanks,
Kaustav
|