Viewing 14 posts - 1 through 14 (of 14 total)
The version of SQL Server I have is 64 bit. However, the version of Excel that I have is 32 bit.
Based on your experience, would this be the...
January 16, 2018 at 4:02 pm
November 16, 2017 at 2:53 pm
Thanks again for the tip!
November 14, 2017 at 8:31 am
Thanks for the tip!
November 14, 2017 at 8:31 am
Thank you for your help Eirikur. Any idea why your suggestion does not work for me?
Dim Cn As ADODB.ConnectionDim
Server_Name As StringDim
Database_Name As StringDim
November 12, 2017 at 3:13 pm
Okay, my code works. But here is the issue: how can I assign a value in each cell within Excel?
Dim NameNovember 11, 2017 at 6:50 pm
Okay, my code works. But here is the issue: how can I assign a value in each cell within Excel?
November 11, 2017 at 2:03 pm
Because of user constraints, I cannot follow through with your stored procedures suggestion.
I tried to debug your previous code, but no error messages execute when the code...
November 10, 2017 at 1:49 pm
Thank you for your contribution, but no matter what variation of your code I try, it does not work.
November 10, 2017 at 1:37 pm
Thank you, so I assume the code would look like this?
Sub ClickButton()
Dim SQL As ADODB.Command
Set SQL = New ADODB.Command
Dim A As Variant
A =...
November 10, 2017 at 11:51 am
I would like only one column: for example,
Dim arr As Variant
arr = Sheets("Sheet1").Range("E3:E20").Value
November 10, 2017 at 11:31 am
Thank you for your response.
I am constrained by user needs.
Therefore I am only inserting one column on a click event due to a user need. ...
November 10, 2017 at 9:17 am
Thank you for your suggestion, but I cannot use a stored procedure in this instance.
Can you please provide an example of working code that uses my logic.
November 10, 2017 at 9:14 am
GilaMonster - Friday, November 3, 2017 3:16 PM???
Don't understand the question
Sorry about that 🙂 Please have a look at the question now.
November 3, 2017 at 8:19 pm
Viewing 14 posts - 1 through 14 (of 14 total)