Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Francisca Perez   on Aug 09 In MS Office Category.

  
Question Answered By: Mason Evans   on Aug 09

Try something like this (no error handling):

'*********************************************
Option Explicit

Sub Extract_Current_Sheet_to_File()
Dim ws As Object
Dim strName As String
Dim strFN As String
Set ws = ActiveSheet
strName = ws.[a1]
strFN = strName & "xls"

Application.ScreenUpdating = False
Workbooks.Add
ws.Copy Before:=Sheets(1)
ActiveSheet.Name = strName
ActiveWorkbook.SaveAs Filename:=strFN, FileFormat:=xlNormal
Workbooks(strFN).Close
Application.ScreenUpdating = True
End Sub

Share: 

 

This Question has 10 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Save a single sheet as a separate file Or get search suggestion and latest updates.


Tagged: