Hi,
I'm trying to export some user inputs to csv file. Purpose is to store their input values so that they do not need to change it everytime.
My macro is as follows but i hit "Object doesn't suppose this property or method: Exportable.Export".
Can someone please advise whether there is any workaround? Thanks.
Sub ExportToXML
dim FilePath
dim docProp
TableID = "IB28"
if Len(TableID) > 0 then
Set docProp = ActiveDocument.GetProperties
Dim tmpFile 'used to create relative filepaths
tmpFile = docProp.MyWorkingDirectory
Set ExportTable = ActiveDocument.GetSheetObject(TableID)
tmpFile = tmpFile & "\Data\updatecranefreeboard.csv"
msgbox tmpFile
ExportTable.Export tmpFile, ","
