Did you consider the path separator (e.g., \)? There is a property that
is system dependent if that's important. Use
"Application.PathSeparator" (without the quotes) to return the path
separator. Anyway, compare the two paths--the one typed in and the one
using the variable.

BTW, you might consider using the Environ function to return the user
name.
for example:
Function GetUserName() As String
GetUserName = Environ("Username")
End Function

Art


maximus73 wrote:
why does the Insert work if i put in a complete path? if i use a
variable for the path it doesn't.


--
maximus73
------------------------------------------------------------------------
maximus73's Profile: http://www.excelforum.com/member.php...o&userid=25877
View this thread: http://www.excelforum.com/showthread...hreadid=522752