You can’t do it, plain and simple. VBA code lives in an Excel workbook and there is no way, that I know, to compile that code outside of a workbook. The long and the short of it is: The users of your Excel programs must have Excel installed.
(I love making unequivocal statements like this. If you want to know how to do something, just say that it can’t be done and someone will be there to show you the error of your ways.)