VBA- Saving a copy of file with both an initial file name and file filter

Question

VBA- Saving a copy of file with both an initial file name and file filter

Newland, Daniel 0

I am trying to save a coy of a file that has the save as window pop up with an initial name and set to an xlsm file type. Here is the code I have but it is not working:

ActiveWorkbook.SaveCopyAs Application.GetSaveAsFilename (InitialFileName:=Sheets("Sheet2").Range("A1") & "Priorpolicyinfo17",FileFilter:= “Excel Files (.xlsm), xlsm”)

Thanks in advance for the help.

Barry Schwarz 3,746 Reputation points

2023-10-11T18:04:21.8533333+00:00

In what way does it not work? Can you give us the complete text of any diagnostic message?

Have you tried recording a macro that does what you want to see what the system does differently?

1 answer

Your answer

Barry Schwarz 3,746 Reputation points

2023-10-11T18:04:21.8533333+00:00

In what way does it not work? Can you give us the complete text of any diagnostic message?

Have you tried recording a macro that does what you want to see what the system does differently?

Answer 1

Tanay Prasad 2,250

Hi,

Try using this code once and let me know if it works-

ActiveWorkbook.SaveCopyAs Application.GetSaveAsFilename(InitialFileName:=Sheets("Sheet2").Range("A1") & "Priorpolicyinfo17.xlsm", FileFilter:="Excel Files (*.xlsm), *.xlsm")

Share via

VBA- Saving a copy of file with both an initial file name and file filter

1 answer

Your answer