![]() Please try again later.")Ĭonnection.ConnectionString = "Provider=sqloledb Data Source=vdd1xl0001 Initial Catalog=SRDK User Id=SRDK_user Password=password Connect Timeout=300" ![]() MsgBox ("Database is currently being updated. Private Sub RetrieveToWorksheet(SQL As String, WriteTo As Range, Optional WriteColumnNames As Boolean = True) I just can't seem to understand how to do it. Seeing as rebuilding the add-in doesn't work, I'm beginning to explore the option of late-binding. After a long time I've determined that it has something to do with the references, seeing as if upon crash I change the reference 'Microsoft ActiveX Data Objects 2.8 Library' to something else, and then back again, the add-in will work again. ![]() It seems that the code will work fine a few times and then all of a sudden trigger an excel-crash. The code itself is working flawlessly, but somehow something got corrupted. I'm trying to write some code for an add-in in excel, which grabs some data from an SQL Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |