#Excel for mac exc_bad_access when break links code
My code is:ĭim excelCon2 As New OleDb.OleDbConnection("Provider=.4.0 Data Source=S:\SanctionsDb\2007-08\points.xls Extended Properties=""Excel 8.0 HDR=Yes IMEX=0""") Dim da2 As New OleDb.OleDbDataAdapter("Select * from where ClsGrp Like '" & ClsGrp & "'", excelCon2) Dim ds2 As New DataSet The info saves back into this cell from VB but the macro seems to not work properly in that only the last value saved it shown. Problem is that there is a Macro in all of the cells in 1 column that keeps a running total by using the cell comment to store a value to stop circular reference problems. The spareadsheet is then saved back to the spreadsheet using another button. Problem saving to spreadsheet with Macros in 1 column I am displaying info in a DataGridView from a spreadsheet that is then altered using buttons by the user.
0 kommentar(er)
