HTML Question....Please

[ribhead]

I am getting a report off the internet that has displays how many parts I need to build and I'm not sure how I can close the activewindow since it is not in Excel? This probalby sounds like a dumb question but I can't find a whole lot in the help file. After the workbook is saved I would like to open it without the user knowing and running the macro that will sort a bunch of gobbily gook so I can read it better.

Sub Parts_Requests()
Application.ScreenUpdating=False
Dim sPath As String
sPath = "H:\"
Dim myname As String
myname = Format(Date, "mm - dd&quot
ActiveWorkbook.HTMLProject.HTMLProjectItems. _
Item(1).SaveCopyAs (sPath & myname & " Parts Needed.xls&quot
ActiveWorkbook.Close
End Sub

For just $19.95 you too can have a beautiful smile.

 

[ribhead]

I guess I will just use this.

SendKeys "%{F4}"

Is there any other way? Not that the code above is extremely lengthy but I would have thought there was something else.

For just $19.95 you too can have a beautiful smile.