I know how to create the Excel file from VB.net, np. I also know how to put a macro in a cell when in Excel or even in VBA. BUT the problem here is I am creating the file programmatically and need to embed the formula into a cell so that when the user opens it later and enters data the function will kick into action.
The function will basically copy over what the user has entered to another sheet and cell.
?????
Help please