macro save as

  1. X

    Vba to save as with path and file name

    What i ultimatly want to achive is that i save the active workbook under the name of the date today in the path i choose. I wrote a little code for that, that partly helped me. the code is as follows: Sub save() Dim location As String location = ThisWorkbook.Path ChDir location & "\History"...
  2. Manolocs

    Rookie in VBA need help

    Hello, I just got a VBA function from a very nice user of this forum Mr. Peter_SSs. This is my first time using VBA/Macros, so I need some help to figure out what I am doing wrong. I have already the Developer TAB in excel 2013 PRO PLUS Macro security is Enable all Macros Thrust access to the...
  3. F

    MODIFY MACRO to value out columns with specified headers!

    Hi All- I have a macro that I currently use to save and value out a worksheet to a new workbook. I need some help in adjusting the macro to only value out columns with specific headers in row 24. For example: if the row headers say either "cost", "revenue", and "profit" (no matter what...
  4. S

    Macro to save as two files at once

    Hi, One of my Daily tasks at work involve preparing time stamp report. I run an SQL Query and get the data I need. Now inorder to present the data to relevant people I copy and paste the data on a template which is named "Promise Data Master" then the second excel file which is called "Hourly...
  5. J

    'save as pdf' macro.....

    Hey. I'm a complete novice when it come to macros and am struggling. I need a macro that will save my selected worksheet by prompting me with the 'SAVE AS' dialog box. All links I have previously read only seem to include a specific file or file name. Can anyone please help?

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