I am importing a csv and doing a bunch of data manipulation until I end up
with a worksheet with 6 tabs. My code had stopped there previously and I
would manually File=>SaveAs and change the type to .xls. This worked fine.
Now, I need to copy the file from my local machine and send it to a few
network locations which I don't want to do manually. Well, when I tried to
have VBA save the worksheet and close it with something like this:
Loc1 = "MASTER" & " " & Today & ".XLS"
Set MasterBook = ActiveWorkbook
With MasterBook
.SaveAs Filename:=Loc1
End With
Workbooks(Loc1).Close SaveChanges:=True
The file gets saved as a text file and I lose all my tabs. How can I have
the file saved as an excel file and not a text file? I both need and
appreciate any help. Thanks.