The object model is completely independent from the IDE and thus is not part of this particular effort to revisit the IDE. I see lots of questions about object model parity between Mac and Windows versions of Office. However, if the connection exists, you should be able to program the resulting querytable using the reduced command set in Office for Mac:įrom Schweib's description, will be able display userforms in this first edition, but we won't be able to actually edit their controls in the interface for a while. If you join Insider Fast and can test this scenario, please do and file reportsĪgainst it if it has not yet been fixed. It is unknown whether this blocking issue has been addressed in the new VBE. With ActiveWorkbook.Connections("ConnectionName").ODBCConnectionĬurrently there is not a programmatic way to initiate a connection. This code fails in the current crappy VBE:
There was a problem when using ODBC as a data source for a PivotTable. You will get to try it very soon, as indicated.
0 kommentar(er)
