Export to csv on Access Point using Button

[#1]

Hi All ,

      I want to give the Send to Excel action to a button on Access Point. How Can i do this?

     Thanks

     sajith

[ashfaq_haseeb]

Hi,

Look at the attached example

Fine tune code accordingly.

Regards

ASHFAQ

[ashfaq_haseeb]

To simplify

use the below code.

sub Export 

    set XLApp = CreateObject("Excel.Application") ' Define Object 

        XLApp.Visible = True 'Visible set as true 

       set obj = ActiveDocument.GetSheetObject("CH01")

  obj.ExportBiff "C:\test.csv"

end sub 

Regards

ASHFAQ

[#4]

Hey ASHFAQ ,

      Thanks for Quick Replay.  I tried your codes in my local client , it works fine . But when i put the qvw on server and try out trough the Access point, i can`t download the file.  

Thanks

sajith

[jerrysvensson]

ASHFAQs code only works if you use plugin as client, in Ajax this will not work.

If you are using plugin, make sure you have correct securti settings in the macro.

[ashfaq_haseeb]

Hi,

Macro only works with IE Plugin.

Try by opening IE Plugin.

Regards

ASHFAQ