how to export worksheet in tableau on mac

To do this, go to the VBA (keyboard Alt-TMV), insert a macro module (Alt-IM), and paste the code into the code pane. This macro should be inserted into Excel (not Word) and put into a standard macro module rather than into the worksheet or workbook event code modules. 'copy cell contents from Word table cells to Excel cellsĬells(iRow, iCol) = WorksheetFunction.Clean(.cell(iRow, iCol).Range.Text)

'Enter table number of table to import', 'Import Word Table', '1') TableNo = InputBox('This Word document contains ' & TableNo & ' tables.' & vbCrLf & _ MsgBox 'This document contains no tables', _ Set wdDoc = GetObject(wdFileName) 'open Word file If wdFileName = False Then Exit Sub '(user cancelled import file browser) 'Browse for file containing table to be imported') WdFileName = Application.GetOpenFilename('Word files (*.doc),*.doc',, _

Sub ImportWordTable()ĭim TableNo As Integer 'table number in Wordĭim iCol As Integer 'column index in Excel It prompts you for the word document as well as the table number if Word contains more than one table. Here is some code that reads a table from Word into the active worksheet of Excel.

How to export worksheet in tableau on mac