Hello,

I do have an access form called T4, which is exported to an excel file, where i do have complex formulas and calculations.

I would some assistance in exporting the table to excel. I cannot re-write the excel file every time the form is edited. When i execute the macro to export them to excel, it gives an error.


Here is the code:

Code:
Option Compare Database
 
Function MacroT4()
...