A
Andy
I have created a template using the template wizard add in for excel. The
template, when saved, exports certain data to an access database. The
problem I'm having is that this works when a new spreadsheet is saved. On
opening the spreadsheet again, it sometimes works fine, giving me the 3
options (update existing record, create new, no action.)
Sometimes though, when I open the already created spreadsheet, I get the
error "No RETURN() or HALT() function found on macro sheet." When I get
this error on opening the spreadsheet, I don't get any options to update or
create a new record on saving the spreadsheet, and nothing is updated when I
open the database. Anyone know how to fix this?
Thanks,
Andy
template, when saved, exports certain data to an access database. The
problem I'm having is that this works when a new spreadsheet is saved. On
opening the spreadsheet again, it sometimes works fine, giving me the 3
options (update existing record, create new, no action.)
Sometimes though, when I open the already created spreadsheet, I get the
error "No RETURN() or HALT() function found on macro sheet." When I get
this error on opening the spreadsheet, I don't get any options to update or
create a new record on saving the spreadsheet, and nothing is updated when I
open the database. Anyone know how to fix this?
Thanks,
Andy