Pausing Macro to save sheet as web page

Hello All,
Using Excel 2010, Windows 7

I have a workbook called oct10hourlywea.xlsm which has 31 sheets for each day of the month. I have the following code that saves the sheet as a web page by going to my web site documents and then publishes it to the web. I need some help that would pause the macro when it comes to entering the file name and then publishes it as a web page to the internet so that I don't have to navigate to the web page document subfolders every day.
Thanks in advance,
Mike

Sub Save_Publish_To_Web()
'
' Save_Publish_To_Web Macro
'

'
    Range("A1:G1").Select
    With ActiveWorkbook.PublishObjects("oct10hourlywea_3424")
        .Publish (False)
        .AutoRepublish = False
    End With
    ChDir _
        "C:\Users\ME\Documents\My Web Sites\mwd\MWD\stats\hourly\2010hourly\oct10hourly"
    Range("A1:G1").Select
End Sub