Help with code to open spreadsheet

[SAC]

I need some vb, vba, or vbscript code to help in opening an excel
spreadsheet and then doing a file save as <filename>.xls

Currently it's a <filename>.xls file, but it's really a web page. Manually
I open it in Excel and then do a file save as <filename>.xls and then I can
import it into SQL Server. So I want to automate the opening and file
saving process.

Thanks for any help you might be able to give.

 

[SAC]

Thanks, Bob.

I really appreciate it!

Set wb = Workbooks.Open("C:\test\abc.xls")
'do stuff
wb.SaveAs Filename:="C:\test\backup\mynewfile.xls"

--
__________________________________
HTH

Bob