Hi,

Is there a way to export access modules to excel. A little background may help. I have created a file that creates an excel file which will need to chart the exported data and calculate other values based on it (in excel). I have the code written in excel but the spreadsheet is created every time so I have no way of getting the code into the excel sheet. I know you can run macros from access but what about macros that run from click events such as a drop down menus. I had thought that they needed to be in the sheet code. Please help. Thanks.

Sam