For the Problem that static web pages in ordinary file server does not have back support for updating,this paper provides a simple VBA code programming to edit and update the static web pages in the Excel worksheet,which has opened a convenient and practical way.