Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I want to give the Send to Excel action to a button on Access Point. How Can i do this?
Thanks
sajith
Hi,
Look at the attached example
Fine tune code accordingly.
Regards
ASHFAQ
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
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
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.
Hi,
Macro only works with IE Plugin.
Try by opening IE Plugin.
Regards
ASHFAQ