-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vba connection string
-
O
Query CSV file using ADO - Run-time error '...is not a valid path' - help with connection string
Hello there, I have used ADO often to fetch Data from SQL Server and .xlsx Workbooks, but I can't seem to figure out what the problem with my connection string is here. Error message : 'C:\Users\Firstname.Lastname\Desktop\temp.csv' is not a valid Path Sub test() Dim myConn As New...- OldNick
- Thread
- ado connection vba vba connection string
- Replies: 3
- Forum: Excel Questions
-
F
Batch replacing External Connection Stream
Hi, I currently have a spreadsheet that includes lots of pages imported from external data (an external website). The links that I used were similar to: https://www.twitrss.me/twitter_user_to_rss/?user=barkingcollege However recently there has been an issue with a security certificate on...- fluffynicesheep
- Thread
- connection strings data link find and replace vba connection string
- Replies: 9
- Forum: Excel Questions
-
J
Excel VBA Connection String / Shell
I have worked with vba for the last year or so and understand a little. For the last two months I have been working on a scheduling template for my restaurants. Currently, it is working great. Most stores are now asking for the ability to be able to compare actual hours worked with scheduled...- jgspencer
- Thread
- vba connection string
- Replies: 8
- Forum: Excel Questions
