Web Development

Ask something
Discussion Locked

Saving Excel without Macros

0 helpful
3 replies

by lewis_rs 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Excel Macro that reads in a .CSV file, and does formatting of the reulting spreadsheet. I then want to save the spreadsheet, without the formatting macro, as a .XLS file to send to users. How do I do this?

3 replies

by dklippert

One way would be to export the sheet to another workbook. Right click the sheet tab and choose Move or copy and then choose a new workbook or export to an existing one. Be sure to check copy, or the sheet will be moved.
This action can be part of the macro:
Sub CopySheet()
Sheets("Sheet1").Select
Sheets("Sheet1").Copy Before:=Workbooks("fred.xls").Sheets(1)
ActiveWorkbook.Save
End Sub

This discussion is closed to new replies.