Export Straight Table

[manojkulkarni]

Hi All,

How to export multiple columns (straight table) as CSV from macro ? I tried using below code, i am getting column data along with html content. How to resolve this ?

set sObject = ActiveDocument.GetSheetObject("CH01")

sObject.ServerSideExport sPath , ", ",0

[tamilarasu]

Hi Manoj

Change ServerSideExport to Export. It should work

set sObject = ActiveDocument.GetSheetObject("CH01")

sObject.Export sPath , ", ",0

Let me know.

[manojkulkarni]

If I replace ServerSideExport to Export, then i cann't execute this from AccessPoint (browser). In my case, i have to export the data to csv thought browser.

[roger_stone]

Export will work if you use the IE Plugin.

[manojkulkarni]

Yes, but it is very difficult to ask everybody to install IE Plugin. Again, if some body want to use it in tablets/mobile then we cann't.