DokuWiki

It's better when it's simple

User Tools

Site Tools


tips:excel_macro

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
tips:excel_macro [2016-01-07 07:40]
202.78.81.34 [Table]
tips:excel_macro [2018-12-12 13:29] (current)
loxley [Office 2007 Complex Tables & Escaping & Hyperlinks & Background colors with Toolbar Addin]
Line 384: Line 384:
     myButton.Style = msoButtonCaption     myButton.Style = msoButtonCaption
     myButton.BeginGroup = True     myButton.BeginGroup = True
-    myButton.OnAction = "ThisWorkbook.SelectionToWiki"+    myButton.OnAction = "ThisWorkbook.SelectionToWiki" '"DieseArbeitsmappe.SelectionToWiki" for german users.
    
 End Sub End Sub
Line 397: Line 397:
     Dim rows As Integer, cols As Integer, thisRow As Integer, thisCol As Integer     Dim rows As Integer, cols As Integer, thisRow As Integer, thisCol As Integer
     Dim inMerge As Boolean     Dim inMerge As Boolean
-    Dim oData As DataObject+    Dim oData As Object
    
-    Set oData = New DataObject+    Set oData = CreateObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}") 'Instantiate DataObject without FM 2.0.
     Set currentSelection = ActiveWindow.RangeSelection     Set currentSelection = ActiveWindow.RangeSelection
     rows = currentSelection.rows.Count     rows = currentSelection.rows.Count
tips/excel_macro.txt ยท Last modified: 2018-12-12 13:29 by loxley