Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: StihlRunning
- Order by date
-
Desperately seeking HELP!
Thank you very much for the replies, I appreciate the help! My PC works very well getting the data the the spreadsheet needs because I have installed the client on my machine and have the ODBC drivers installed as well. I was hoping to publish the spreadsheets on our local intranet and let the...- StihlRunning
- Post #12
- Forum: Microsoft: Office
-
Desperately seeking HELP!
Thanks again for all the help, I truly appreciate it! my code: Option Explicit Sub connectDB() Dim conn As ADODB.Connection Dim rs As ADODB.RecordSet Dim strHost, strDatabase, pwd, strUser, strPassword As String Set conn = New ADODB.Connection strHost = "46!#!dbs" strDatabase = "n!$c"...- StihlRunning
- Post #9
- Forum: Microsoft: Office
-
Desperately seeking HELP!
I can ping the database server just fine from any location(user pc). So if I can ping it, shouldn't I be able to connect to it via VBA ADO? Thank you for your help!- StihlRunning
- Post #4
- Forum: Microsoft: Office
-
Desperately seeking HELP!
In desperate need of help with Excel VBA ADO access to Oracle tables. I have to deliver this Excel sheet to multiple people and I want the Excel file to be populated with the most recent data from a Oracle DB every time they open it. I don't want them to have to configure a DSN or TSN and it...- StihlRunning
- Thread
- Replies: 13
- Forum: Microsoft: Office
