Ãðóïïèðîâêà êîëîíîê â ëèñòå Excel èç Access |
Private Sub Êíîïêà0_Click() 'îòêðûâàåòñÿ ñóùåñòâóþùèé äîêóìåíò Dim XL As Object, XT As Object, o As Object Set XL = CreateObject("Excel.Application") Set XT = XL.Workbooks.Open("R:\Ìîÿ êíèãà.xltx") 'îòîáðàæåíèå Excel Set o = XT.Sheets("Ìîé ëèñò") o.Columns("C:G").Select ' ÇÄÅÑÜ ÎØÈÁÊÀ: error 1004 ìåòîä select èç êëàññà range çàâåðøåí íåâåðíî o.Selection.Columns.Group XL.visible = True End Sub
http://www.sql.ru/forum/1265840/gruppirovka-kolonok-v-liste-excel-iz-access
| Êîììåíòèðîâàòü | « Ïðåä. çàïèñü — Ê äíåâíèêó — Ñëåä. çàïèñü » | Ñòðàíèöû: [1] [Íîâûå] |