Need to save/write ranges to a workbook
Actually, I was able to do it with the following:
Sub DoFileRead()
Dim fileReadName
Application.GetOpenFilename ("Excel Files (*.xls), *.xls")
If fileReadName < False Then
ActiveWorkbook.SaveAs Filename:=fileReadName
End If
End Sub
Many thanks for all the help!
|