Will share the details privately since the file might be proprietary
information (just to be on the safe side)
Thanks.
(a) please don't send private copies of your replies to me - I am
subscribed to the list
(b) I doubt I'll be able to help you but as I said I doubt anybody will
be able to help unless you state the actual error message you're seeing.
PS personally I'm not going to click on a link and enable javascript
to download a file, let alone load the downloaded file into LO and
enable macros. I can be just as paranoid as you 
FWIW, in private email you said "Click Next or move to the Last tab
then Validate, that's where the error pop ups." That suggests to me
that the error is in macro code that runs when you click Validate. You
might want to extract that code and look for problems, but unless you
tell us the error message as well as post that code, nobody can help
you.