I'm not sure if it's possible.

Maybe if that other user shares the desktop???

I'd ask in a windows forum.

"J.W. Aldridge" wrote:

Thanx... Very helpful info.. (can use that in the future)

But my original question was that can I save it from a shared drive to
someone else's pc.

Example: Using the following code, JALD is the users name. If I know
the computer name, how could I get it to work?

Thanx

Sub Macro4()
'
' Macro4 Macro
' Macro recorded 9/28/2007 by FTN
'

'
ChDir "C:\Documents and Settings\JALD\Desktop"
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\JALD\Desktop\Book200.xls",
FileFormat:=xlNormal _
, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False, _
CreateBackup:=False
End Sub

--

Dave Peterson