Hi,

MY office desktop have just upgraded to windows 7, thus I am facing the problem of defaulted desktop filepath in windows 7

for windows XP we can change username to All users but it does work in windows 7. Then, try to use Public but still does not work.

Can anyone help me please.



ActiveWorkbook.SaveAs Filename:="C:\Users\Public\Desktop\Book1.xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False