save sheet as new file

  1. W

    VBA Code to save worksheet to new workbook

    Hi, There are lot of similar questions but somehow its not working out for me. I want to save the sheet (Source) from the active workbook as a new workbook where sheet name remains same and work book name must be "Source dd/mm/yy".xlsx. This workbook needs to be saved in the same path as...
  2. F

    Copy Sheet into a new workbook and save it where user desires.

    Hi there, I am currently trying to make this code work, basically I am getting two codes I found and putting them together but it isn't working exactly how I expected. Instead of saving where the user selects, it is saving else where. Can someone shine a light on this please? The main code...
  3. A

    SaveAs sheet not active workbook

    I have a project I am working on where I would like to save one of the sheets in my workbook as a .csv document. Below is the code I am currently using: Sub myExport_Click() Dim ws As Worksheet Set ws = Worksheets("Export") ws.SaveAs Filename:="myExport", FileFormat:=6 End Sub This...
  4. I

    Macro to rename each excel sheet, and save each sheet separately

    I consider myself to be proficient with Excel, and I've taught myself a little about Macros but there one I am having no luck on. My Scenario: I have an excel file with a lot of sheets, lets say 30. The sheets are named "First Last" (as in first name space last name). I open the file, use a...
  5. S

    Macro to automate : a.) Saving of Open Worksheet as new Excel file, b.)Print command to print 2 copies each with different footer, and some more queri

    All for the same file :) a.) I have an invoice template in one excel file in which I fill in data, out of which some of it auto fills as it is linked to another excel file in which the master data is stored and updated. I wish to edit this invoice "template" (if u may call it that:)) and once I...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top