name file using cell

  1. E

    Saving workbook to CSV with Custom Name

    Hi Everyone, I have figured out some code to copy all the data from a table, create a new workbook, paste the data and then save the workbook as a CSV as the name of the original table the data came from. I now am trying to figure out how to save the file as a custom name from cell L23 from...
  2. D

    Run-Time error '1004'

    Hi everyone, Recently I have started recording and editing macros. I am really new in this field and I am not able to find the solution for one of the latest macros I have recorded. When I run the macro below I get the following error message: Run-Time error '1004': Method...
  3. F

    Save file based on cell value

    Is there a way that when saving a file the file name will automatically become whatever value is in a specific cell? For example cell B3 in a form will be the item number. When the user saves the file I would like the file name to automatically save as whatever is typed into cell B3. Item...
  4. H

    HELP: VBA Macro: Save a sheet and name it using a cell on another sheet.

    Hey guys, Wondering if you can help; I have a slightly specific one which I'm struggling to crack. My workbook has 4 sheets: 1) 'ORIGINAL' (as an example, lets say A1 value = 'face', A2 value = 'cheese' and A3 value = 'head' 2) 'TEXT1' 3) 'TEXT2' 4) 'PRINTOUT' In short I'm trying to save...

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