save as file

  1. G

    Help to create vba for "save as" and create PDF

    Hi, I don't know anything about vba so i need some help here. I got this code: Private Sub GemSom_Click() MkDir "C:\Users\Martin\\\\\\\TEST" & Range("b6").Value & " " & Date Dim Path As String Dim FileName As String FileName = Range("b6").Value & " " & Date ActiveWorkbook.SaveAs...
  2. K

    Picture from Excel to a file

    Hi Guys, I'm new in this forum and VBA. I need a code that can export a picture from excel into a folder on my desktop. I would like to insert the link as a range and the the name as well (maybe using offset or something similar) - Can anyone help with this (don't have to incl. the range)? :)...
  3. A

    How can I force File,Info,Document Properties to show when saving file?

    When I use File,Save or File,Save As, I would the File,Info,Properties,Advanced Properties,Summary tab to show up..
  4. S

    Add Password Proction when selecting Save As to the Workbook

    Hi, I have a Workbook that users should be able to open and work on. But users shouldn't be able to save the workbook on their computer. How can I add a password protection when someone clicks Save As and Save? I included the code below to the Excel Object "This workbook" but it's not working...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top