How to Save Excel Workbook in Specific Folder by vba code

Create A Module and Use This Code
Sub savewithVariable()
Dim Myfile As String
Myfile = ActiveWorkbook.Name
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs filename:="C:\Users\Dell\Desktop\Match\" & Myfile
ActiveWorkbook.Activate

End Sub

Тэги:

#How_to_Save_Excel_Workbook_in_Specific_Folder_by_Vba #how_To_Copy_a_Excel_Workbook_in_there_Folder_VBA #Can_We_Copy_Excel_Workbook_By_Vba #Save_As_Excel_Workbook_Using_VBA #Can_we_Save_excel_workbook_by_vba_in_any_folder

Скачать видео