score:1
Accepted answer
Change your GetSaveAsFilename to
flToSave = Application.GetSaveAsFilename _
(ThisWorkbook.Path & "\" & flName, filefilter:="Excel Files (*.xlsm), *.xlsm", _
Title:="Save FileAs...")
This starts the SaveAs in the specified directory
Source: stackoverflow.com
Related Query
- Saving Excel File by cell value and saving in current directory where the file was opened
- How to search a text file for multiple matching strings and put the sum value in to an Excel cell
- Excel Formula to compare single cell value with the whole column and return the value for a particular row where match found
- Creating Directory and saving the excel file via VBA
- excel vba: lookup second line of text file and update spreadsheet where cell = value and update other cell in same row with value from text file
- How to find text in a column and saving the row number where it is first found - Excel VBA
- Detect the language in which Excel is setup and show it in a cell of the file
- Need to delete the previous row in a Excel sheet based on a cell value in a current cell in Excel VBA
- Excel - Delete current row and row above based on cell value
- Match cell value from two sheets and paste where the value is met, starting from one cell below
- Excel 2013 cannot find and open the file in ThisWorkbook directory
- Using excel VBA open file based on cell value with path composed on the fly from same value
- excel vba: find the row of a cell with a certain value and put that row number in another cell
- excel vba look for keywords list based if value lookup exists and then edit the value of another cell
- Excel cell auto open/close file window and put filename and path as cell value
- In Excel and VBA, how to set value of cell to the formulas result rather than the formula
- How do I use VBA to keep the value of a cell in Excel with a limit and loop when needed?
- Excel VBA - Searching a column for a particular value and returning the value from the adjacent cell
- Copy Excel cells, evaluate content, and copy a file looping over the cell contents as filename
- VBA: Automatically saving the excel sheet as V-1, V-2 and V-3 depending on if there is a file with that name already in the folder
- Excel VBA code to copy a range of cells in a row and paste in a different sheet but same row/range, when the value on 1st cell changes
- Excel insert a cell value into a function and return the new value (not the formula)
- Excel - search keyword in TXT file and write line where keyword is found to an excel cell
- Excel VBA - Loop through a column of cells and search for each cell value in the workbook
- Different values in excel value debugger and actual cell value (actually the value doubles)
- Excel VBA to save file name as CSV and Cell Value
- Excel Macro to change cell alignment, borders and wrap text if a value has been entered into another cell in the same row
- Excel changes the current working directory when .py file is called
- Search a column for words in a table on another sheet and insert the value from the cell next to it in the current cell
- Excel VBA - Select cells based on the value of another cell and then Autosum - Is it possible
More Query from same tag
- Using a named range in VBA to create a dynamic priority list
- get full value from partial id when scraping using VBA and selenium
- SQL Issues With DateFields When Using FOR XML (to create JSON String)
- docmd.transfertext using queryname
- Passing variable between function and sub
- Creating query in VBA to get data from table with a name that is a SQL-keyword
- Excel VBA Compare Array
- VBA word Macro not working across different computers
- Runtime error 462 in regard to MSForms.DataObject
- Concatenate a Variable Number of Fields
- excel bubble chart overlapping data label
- VBA-Excel. How can I handle hide/unhide rows based on Private Sub Worksheet_Change(ByVal Target As Range)?
- Excel - Drop down list values based on values in rows matching certain text
- Lookup 2 values in a table and write to a 3rd cell in the table
- Get already opened Edge (not IE) browser window(s) and scrape contents
- vLookup error for VBA in Excel
- Looping Through Worksheets Excluding Specified Worksheets
- VBA function that will look in cell comment that have multiple lines for a specific line
- Macro for removing conditional formatting fill color Red
- Excel VBA: Dates displaying as text even though date format is set
- How do you delete multiple columns (possibly non-consecutive) based on an array of number?
- Unified Functional Testing: How to schedule a .tsp file to run?
- VBA Excel Line Break in Cell
- VBA, ClearContents in columns only where range = string
- VBA Macro to delete row if cells in B,C,D,E,F & G all = "0"
- I'm looking for a VBA code to copy text in the active slide
- Excel Merge cells if other cell matches
- Date format dd/mm/yyyy read as mm/dd/yyyy
- Importing data from SQL to Excel
- Get ?? when taking chinese characters from excel sheet and exporting to mysql via vba
