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 |