I’d recommend getting rid of the VB program. Record an Excel macro directly within excel to save a copy of the file to where it needs to be saved to be on the website.
Then add a scheduled task to launch excel passing it the path to the excel workbook.
After you create the macro, in the macro editor select ThisWorkbook from the project. In the first dropdown menu select Workbook. This will open the Excel macro which runs when the workbook is opened. Give it the name of the Sub which was created when you recorded the Macro.
From now on when the workbook is opened it will update it self and publish it self to the web server.