Hey, Im currently running a macro which seperates the worksheets in my work book into seperate files 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.
I found this code on a dotcom website called excelforum. The subject was "Save to Desktop". The function identifies the desktop path.
Function GetDesktopPath() As String
Dim DskTop As String
Dim WSH As Object
Set WSH = CreateObject("WScript.Shell")
DskTop = WSH.SpecialFolders("desktop")
GetDesktopPath = DskTop
'Free the object reference and memory allocated
Set WSH = Nothing