save worksheet

  1. S

    How do I save the worksheet into a new workbook with the file name referencing from Sheet1 C3 via VBA?

    How do I save the worksheet into a new workbook with the file name referencing from Sheet1 C3? Currently this is the vba code that I am using right now. Sub Billing_Milestone() Worksheets("Billing Milestone").Copy With ActiveWorkbook .SaveAs Filename:= "C:\Users\Desktop" &...
  2. B

    VBA to create a copy of a worksheet on my desktop but with values rather than formulas

    Hi, I have written my first VBA macro using the macro recorder. I understand that the recorder adds a lot of unnecessary code but I needed to start learning somewhere! The macro currently creates an export PDF on my desktop of a specific worksheet, after entering specific values in some cells &...
    • barnabyr
    • Thread
    • code save worksheet values values not formulas vba
    • Replies: 5
    • Forum: Excel Questions
  3. G

    Export one sheet as CSV

    Hi everyone... I'm looking for a way to export (save) one worksheet of many through VBA code. I tried saving as a csv but after changes are made to the rest of the appication, I need to be able to restore the single sheet intact as it was before. The reason is so that individual users can save...
  4. T

    VBA novice needs to amend code !

    Unfortunately my desire outstrips my ability once again! Can someone please help amending this code to do the following Save any sheet not starting with an X to a new workbook and then delete it. I'd like to be prompted as to where i'd like to save the files and enter a standard prefix...

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