![]() ![]() ![]() Your code uses late-binding and doesn't require a "Reference" so long as the library is available on the machine. Sorgu1 = sorgu1 + " from where = " + "'" + makine + "'" Makine = Sheets("Dashboard").Cells(2, 11).Value ThisWorkbook.FullName & " extended properties=""Excel 12.0 hdr=yes""" Set con = CreateObject("nnection")Ĭon.Open "provider=.12.0 data source=" & _ ![]() I don't know code is important here but I'll share it anyway. How can I run this? Normally, in windows, you choose tools > references and check oledb connection but there isn't a tools option in Excel Mac. I have write a macro in Excel 2016 on a windows pc via oledb connection. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |