save file macro

  1. S

    Save the files in a selected folder using filedialogfolderpicker

    Hi all I need your valuable expertise in modifying/tweaking the below code a little bit to make it work wonder. From below, myCell is a range of values containing the name of the files to be saved got produced out of this macro. Instead of providing the fixed path/folder to save produced...
  2. S

    Save multiple files into selected folder using file dialog folder picker

    Hi all I need your expertise in modifying/tweaking a little bit in the below mentioned code to make it work in a better way. <tbody> For Each myCell In TheRange If Trim(myCell) <> "" Then Sheets("Cover").Cells(myCell.Row, 66).Copy Range("M31").Select...
  3. N

    VBA - Open workbook, Copy all sheets, paste as values, save as new workbook

    Hello Long time user, first time poster. I am using Excel 2010. I am currently trying to create a Macro that will do the following. Open a workbook based on text written in cell Copy all tabs from the opened workbook Paste as values Then save as a new workbook, also if possible from a...
  4. M

    Email Excel Tabs Macro

    I need a macro that sends each tab in the worksheet to an email address listed in the cell of that worksheet. If it doesn't then I need the tab to be skipped. I also need the worksheets that have been sent to be saved in a specific folder in different files and the tabs that haven't been...
  5. N

    Need help - macro to save file. Path and filename in cells

    Hi, I'm very new to this so I would really appreciate your help on this matter. I have an excel database, column A with employee names and Column B with supervisor name. I would like to build a macro which will save a specific file (called "template.xlsx") in a folder named as Column...

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
Back
Top