getsaveasfilename

  1. M

    Filling Save-As file name window

    My goal is to have the Save-as dialog box open at the end of the macro and to offer the xlsx format only, so that the VBA code will be dropped when the file is closed. I worked on this task in a copy of my original macro file and it works (see code below). It even fills the file name window...
  2. K

    Help with VBA to Save as PDF

    I want to save certain sheets as a PDF file with a specific path, have a default file name with the option to edit the file name which also opens the PDF file. Seems to work with desired path and option to change default file name, but the PDF file is never saved and the code continues to the...
  3. H

    initialFilename Save as Excel

    Hi, I'm using the following code to save as macro enabled excel with initial filename in the Application.GetSaveAsFilename: Private Sub LagreSomExcel_Click() Dim fileSaveName As Variant Prosjekt = Sheets("Forside").Range("E3").Value Rapportnavn = Range("C2").Value...
  4. M

    GetSaveAsFilename ([initialfilename]) not populating

    My company is behind the times and I'm forced to code everything so that all workbooks are saved in XLS format (not XLSX or XLSM). To force this I added the following code to the 'main' macro whose primary purpose is to prepare a sheet so that about 25 other macros are able to work on it. The...
  5. B

    SaveAs Dialog Box with Custom Filename and .xlsx extension

    Hello, I have been working on a macro to save a file with a custom filename but I can't seem to find a way to put the .xlsx extension on the end of the filename. Dim sFile As String sFile = Application.GetSaveAsFilename("RFI " & Range("G5").Text) If I have "120" in cell G5, ideally, the...
  6. T

    Application.GetSaveAsFilename Prompting on Read Only Files

    I've just upgraded to Excel 2010 from 2003. An internal add-in that is heavily used uses the Application.GetSaveAsFilename method to prompt for file names to be used for an export process (exporting information from the current Excel file into an xml configuration file). In 2003, even if they...
  7. M

    Restrict File Name with getsaveasfilename

    I have created an Inventory System using Excel with Userforms. I am trying to create a "Backup" function into the program where I create a new workbook and copy all my sheets to the new workbook. I am using the getsaveasfilename option to save the backup file. I set my initial file name in...

Watch MrExcel Video

This Week's Hot Topics

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