Hello Every one
Dim T as Variant
T = InputBox("Enter Your CORP ID")
ChDir "\\Client\C$\Users\T\Desktop"
ActiveWorkbook.SaveAs Filename:= _
"\\Client\C$\Users\T\Desktop\From Application to MIS_V.0.1.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
I have above code but code notrun , I get Run Time Error 76 Path not found
Dim T as Variant
T = InputBox("Enter Your CORP ID")
ChDir "\\Client\C$\Users\T\Desktop"
ActiveWorkbook.SaveAs Filename:= _
"\\Client\C$\Users\T\Desktop\From Application to MIS_V.0.1.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
I have above code but code notrun , I get Run Time Error 76 Path not found
Last edited by a moderator: