Showing related tags and posts accross the entire site.
-
Hi Sam, Yes, that sounds like a lot of effort. Lifting a finger and all... You could code something that retrieves data from the other workbook without using the query editor. Basically an Open-Copy-Paste-Close action would do the trick. A userform could be used to create some flexibility for parameter...
-
Here's some code i've used in the past to create tables using ADOX Private Sub createTable(ByRef adoxParentCatalog As Object, _ ByVal strTableName As String) On Error GoTo Error_Handler Dim adoxTable As Object ' ADOX.Table Dim adoxColumn As Object 'ADOX.Column 'Create new instance...
-
Connection strings are tricky and it's also tough to experiment with your example (as it's linked to your data), but Yes/No seem strange anyhow. Have you tried False? Or...removing the parameter all together? Just a long shot