How can we convert an Excel worksheets that includes macros VBA(Visual Basic) to a webpage?

Answer 1

If it contains VBA macros, the macros themselves probably cannot be converted, or at least easily, because it uses the Visual Basic for Applications language for the code, which is impossible to use as-is on a non-Windows OS.

Even on a Windows OS, it is impossible if the user is not using a Microsoft web browser capable of running ActiveX controls / has them disabled (which is good to have disabled for non-trusted networks & websites for security reasons because it allows nearly any ActiveX control to run without restrictions).

Best bet is to know what it does by reading (and understanding) the VBA code contained by it and create a Javascript wrapper around the created webpage (or template if filling one in) which does what the VBA macro would do.

Answer 2

Not 100% sure here but maby saving and reading as a csv file is worth looking into. again im not sure but an article i read sounds familiar to what your askimg