I have a problem for some users to save an excel file with the VB6 app.
Some users are under XP, Window7 and Window8.
So the Desktop path is not the same.
How can i adjust below code to always save in on the desktop, no matter the OS version?
xlObject.ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\all users\Desktop\New locations "