Can anybody help me debug this line in the Macro I'm trying to do please,
Dim NewFN As Variant
NewFN = "Users/gozmani/Desktop/IG Networks LTD/Inv" & Range("F4").Value & ".xlsx"
ActiveWorkbook.SaveAs NewFN, FileFormat:=52
I tried different file format codes but can't make it work, I get the Error 1004 message "Your changes could not be saved to 'Inv2091.xlsx', but were saved to a temporary document...."