fileformat:=52

  1. J

    Fileformat not working

    I'm extremely new to building macros so here is my situation. We have users opening a macro enabled excel file on our intranet. I'm trying to keep users from saving the file back to the intranet once opened. I want the user to save the file to their drive once opened. Once a user opens the file...
  2. A

    New macro enable workbook generated from a macro enabled template

    Hi When I generate a new workbook from a macro enable template, I am not able to set the Save as type to: "Macro enable workbook" as default file type. This macro does not wprk for the New workbook... Sub SaveBook() Dim sFile As String sFile = Range("C7").Value & ".xlsm" ActiveWorkbook.SaveAs...

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