Hey, Im currently running a macro which seperates the worksheets in my work book into seperate workbooks on my pc and then saves them individually on the desktop. It all works great until i sent it to another pc. The problem is that i have it saving through one specific pc. Ive tried playing with the code etc but to no avail. Here is where i believe the problem to be.

ActiveWorkbook.SaveAs Filename:= _
"C:\Users\WORKPC\Desktop\Address Information.xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False

Is there away to manipulate the code to save on someones desktop automatically?

Thanks