-
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.
sconnect
-
J
Can anyone figure out or explain why this code doesnt work? (passing SQL string)
Hi, cant figure out whats wrong here: This Works with the following SQL string in cell P9 SELECT * From [DataSheet$] WHERE Region='UK' But it fails with this, where the Region is in cell P7 SELECT * From [DataSheet$] WHERE Region='" & REGION1 & "' Sub Test2() Dim REGION1 As String, SQLSTR As...- JumboCactuar
- Thread
- dbpath dim sconnect sqlstr string
- Replies: 7
- Forum: Excel Questions
-
J
Using ADO to query other Excel Workbooks - Questions
Hi, i found this great code which allows you to query the current workbook, and also closed workbooks. Allows you to SQL query which i am finding a better way of "advanced filtering" data in the same workbook. Are there any limitations to this? Also if using ADO on an external workbook (closed...- JumboCactuar
- Thread
- data dbpath dim sconnect workbook
- Replies: 3
- Forum: Excel Questions
-
D
VB Script message box help
Hi Everyone, I wonder if you can help. I have a hta file which loads in a directory of files from a database. When the user clicks the select box (dir2) I want a message box to display what option they selected. Can anyone help. This is my code: <html> <head> <title></title>...- Dakker221
- Thread
- dim objrs objrsnormalised_name sconnect set
- Replies: 0
- Forum: General Discussion & Other Applications
