getsaveasfilename

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...

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...

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...

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...

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...

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...

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...