VBA save workbook excel

[miew]

I trying to save file in a specific folder using VBA but it is only working until folder STUDENT NAME LIST but it supposedly save in folder year 2022. Any suggestions?

```vba
Sub SaveResult()
Dim MyFile As String
MyFile = "\\uni\admin\Course Code\Lecturer Name\Semester\Class\STUDENT NAME LIST \2022" & Sheets("RESULT").Range("A5") & "_" & Sheets("RESULT").Range("E11") & "_" & Sheets("RESULT").Range("E13") & ".xls"

'create result in XLSX format
ActiveWorkbook.SaveAs "\\uni\admin\Course Code\Lecturer Name\Semester\Class\STUDENT NAME LIST \2022" & Sheets("RESULT").Range("A5") & "_" & Sheets("RESULT").Range("E11") & "_" & Sheets("RESULT").Range("E13") & ".xls", FileFormat:=xlOpenXMLWorkbookMacroEnabled

'ActiveWorkbook.Close
Application.DisplayAlerts = True

MsgBox "Saving Complete! Have a wonderful day~"

End Sub
```


It only saves in the student name list folder as 2022Adam_May_14052022 and under 2022 folder not in 2022 folder

 

[aaewalsh]

It looks like the issue is with the way the file path is being constructed in the SaveAs method. Currently, the path is being constructed as follows:

"\\uni\admin\Course Code\Lecturer Name\Semester\Class\STUDENT NAME LIST \2022" & Sheets("RESULT").Range("A5") & "_" & Sheets("RESULT").Range("E11") & "_" & Sheets("RESULT").Range("E13") & ".xls"

This creates a file path that includes the "STUDENT NAME LIST" folder and then the "2022" folder within that. To save the file in the "2022" folder directly, you should change the file path to:

"\\uni\admin\Course Code\Lecturer Name\Semester\Class\2022\" & Sheets("RESULT").Range("A5") & "_" & Sheets("RESULT").Range("E11") & "_" & Sheets("RESULT").Range("E13") & ".xls"

This way the 2022 folder is the last folder in the file path. Also make sure that the folder exist or the file will not be saved in the desired location.