save as macro

  1. S

    Creating an XLSX from from tabs in an XLSM file

    I'm taking four tabs in an XLSM file and creating a new XLSX file. The XLSM has many tabs, and I'm creating 10 XLSX files from this one big XLSM file. When I run my macro, I'm getting the below message: The following features cannot be saved in macro-freeworkbooks: VB Project To save a file...
    • Stevep4
    • Thread
    • creating file macro excel to xlsx save as macro visual basic
    • Replies: 1
    • Forum: Excel Questions
  2. T

    VBA to save in a folder specified in a cell as well as saving document as a name specified in cell

    Hi All, Appreciate any help with this. I want to save a file using VBA into a specified folder on the server. Most of the save location will not change so I would like to have the first part up until the final folder hard coded into the vba. However, I would like the final folder name to be...
  3. V

    Trying to save as 'filename'

    Hello, I'm having trouble with what should be a very easy excel problem. I am opening a file from my desktop and running it through a macro. I then need to save it to a specific folder and would like the macro to do this for me. I tried just recording a macro: ActiveWorkbook.SaveAs...
  4. R

    Change a Cell based on a List and Save the Worksheet with that Cell Name

    So I haev the following VBA, pretty staright forward code to perfomr a Save As with the name in A1. But I would like for A1 to change "as a data validation/list" based on a list that I have (say: D1:D10) and save the Worksheet with the Cell value Name for each of the 10 records. Sub...

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