Export to excel

[rajupatel544]

I have data in ms-access database.I want to export it to Excel on click of a button which is in front end developed in core java.
I am working on frames NOT applet.


I developed a macro in access to export data to excel.
But i dont know how to run this macro on click of a button in core java application.
Is it possible to run ms-access macro on click of a button in core java application?


If not possible kindly suggest some other way.


Kindly do me a favour in this regard.


Thanks in advance.


___________________________
software application development | website development | java development

 

[surreypcsupport]

When you call the Excel executable add a space after the file name then '/x' and then the macro name without a gap. e.g.

....\workbook1.xls /xMacroName

Or alternatively you could add a call to the macro from the open_workbook event or whatever event you need to trigger it.