Dismiss Notice
Welcome to Our Community
Wanting to join the rest of our members? Feel free to sign up today.

Export to excel

Discussion in 'Programming' started by rajupatel544, May 11, 2009.

  1. rajupatel544

    rajupatel544 New Member Webmaster

    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
  2. surreypcsupport

    surreypcsupport New Member Webmaster

    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.

Featured Resources (View All)

Share This Page