There simply is no one else out there producing content to this detail presented to this standard. Andy makes it look effortless but there must be a lot of hard work and detailed research behind the preparation of each WiseOwl video. Thanks again Andy for this content, it’s also worth pointing out that there is a goldmine of material at the WiseOwl website too.
Thank you Andrew for your selfless efforts and commitment in making this fantastic tutorials 👏👏👏 ... I really don't know how to thank you enough for the community service you do. And effortlessly answer each and every ones comments and questions, 👏👏
Hi Wayne, as far as I know you can't pass a workbook password to the connection string for ACE.OLEDB. There's a long discussion which includes a workaround for this issue here but I haven't tried it myself www.vbforums.com/showthread.php?842899-RESOLVED-How-to-get-data-from-a-password-protected-closed-excel-workbook I hope it helps!
Thank you for everything you do for the community
Thank you for watching, Garrett!
There simply is no one else out there producing content to this detail presented to this standard. Andy makes it look effortless but there must be a lot of hard work and detailed research behind the preparation of each WiseOwl video. Thanks again Andy for this content, it’s also worth pointing out that there is a goldmine of material at the WiseOwl website too.
Thank you for the comments and recommendations Brendan, it's much appreciated!
Thanks Andrew. Your diveos are really gems. 👍
Happy to hear that you're finding them useful, thanks for watching!
Thank you Andrew for your selfless efforts and commitment in making this fantastic tutorials 👏👏👏 ... I really don't know how to thank you enough for the community service you do. And effortlessly answer each and every ones comments and questions, 👏👏
Ah Frik, you're very welcome! Thank you for your support and comments as always!
Thanks Andrew. Loving this series.
Happy to hear it Kevin, thanks for the comments!
Thank you Andrew for your effort and amazing content.
My pleasure Ravi, thank you as always for your comments and support!
This is just exactly, what i need. Thank you so much 🙏
Happy to hear that it was useful Nabilah, thank you for watching!
Good explanation thanks again 👍
Thank you Panner!
Amazing as usual. Thank you very much.
Thank you Yasser!
Can you connect to password protected workbook using this type of connection?
Hi Wayne, as far as I know you can't pass a workbook password to the connection string for ACE.OLEDB. There's a long discussion which includes a workaround for this issue here but I haven't tried it myself
www.vbforums.com/showthread.php?842899-RESOLVED-How-to-get-data-from-a-password-protected-closed-excel-workbook
I hope it helps!
@@WiseOwlTutorials thank you
@@wayneking6667 You're welcome!