Hello Sir, I am very happy to follow your videos, and I would like to ask you a question: How do I access the data source on a site that have searching box using VBA Selenium?
Hello sir, I am getting this Error, Please Tell me how to solve this error "[MicroSoft][ODBC Drive Manager] Data soure name not found and no default driver specified" Thanks.............
Hey not sure if you found your solution, but I had the same issue. The problem is the connection string you are using. If you have a 64 bit, you have to use connection string "Driver=Microsoft Access Text (*.txt,*.csv);Dbq=c:\txt\; Extentions=asc,csv,tab,txt;". Hope this helps having the same issue.
Hi Andrew, the best vba there is on YT, thank you for nice explanation of complex topic.
You're very welcome Janez, thanks as always for watching and for commenting!
The information you provide is very valuable.
Thanks Ibrahim!
As expected, really informative content once again.
Thanks for watching!
Thanks Andrew, your videos are so beautiful
Ahh thanks! Happy to hear you like them, thanks so much for watching!
Thanks Andrew👍
You're welcome! Thanks for watching!
Great video! How would the code change if your file was saved to One Drive and the workbook path was an https address?
Thanks Andrew..
You're welcome Kevin, thanks for watching!
Thank you Andrew for an amazing video. Hope to see more videos from you.
You're very welcome, thanks as always for watching!
Hello Sir, I am very happy to follow your videos, and I would like to ask you a question: How do I access the data source on a site that have searching box using VBA Selenium?
Hello sir, I am getting this Error, Please Tell me how to solve this error
"[MicroSoft][ODBC Drive Manager] Data soure name not found and no default driver specified"
Thanks.............
Hey not sure if you found your solution, but I had the same issue. The problem is the connection string you are using. If you have a 64 bit, you have to use connection string "Driver=Microsoft Access Text (*.txt,*.csv);Dbq=c:\txt\; Extentions=asc,csv,tab,txt;". Hope this helps having the same issue.
Please upload power query tutorials...
Can we add criteria in sql with this type of files?
Hi! Yes, you can add a WHERE clause to the SELECT statement which you use to set the Source of the Recordset object.