Macro to export inputbox text to csv

Wed, 31 Jul 2013 10:14:37 GMT

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, ","

Re: Macro to export inputbox text to csv

marcus_sommer — Wed, 31 Jul 2013 11:21:39 GMT

The inputbox is not a table and support none export, except as picture.

As workaround you could read the inputbox on row and column level or you put the user-content (these variables) in a hidden straight-table or pivot and export this object.

- Marcus

topic Macro to export inputbox text to csv in QlikView

Macro to export inputbox text to csv

Re: Macro to export inputbox text to csv