file name from cells data

  1. S

    Open and print a section of word document as pdf

    I have a macro enabled workbook to produce cost estimates for customer proposals. I have built a macro in cost estimate workbook to create a customer specific proposal in word from a word template that uses mail merge fields to pull in the data from various cells in the cost estimate workbook...
  2. J

    Import button based off cell value = file name

    So I have a report that is emailed to me daily, I have a macro enabled to save the files automatically to a location on my desktop (C:\Users\rwebber\Desktop\TSA Hourly Report) and the file saves as SSC Hourly Update "the date it was emailed". I would like to place a button on my page called...
  3. H

    Help Modifying Macro - Naming As Contents Of A Cell

    Hi all, I have the following working macro below. Sub Button1_Click() ActiveSheet.Unprotect "password" Dim wbNew As Workbook Application.DisplayAlerts = False Worksheets("Page4").Copy Set wbNew = ActiveWorkbook With wbNew With .Worksheets(1).UsedRange .Value = .Value End With...
    • Helen842000
    • Thread
    • debug error file name from cells data macro - help save as data in cell
    • Replies: 3
    • Forum: Excel Questions
  4. S

    Help : Macro to save a woorksheet to a new workbook using data from a cell as the file name

    Is it possible for a macro to save a worksheet to a different workbook with the "file name" coming from a cells data? I have a rental form that has a cell that is the invoice number. It increments by 1 each time a new form is opened. I would really like to save each invoice to a different...

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