Changing "C:\Filename" to "\\CompName\C$\Filename"

[jbart]

It seems to work correctly the way it is coded. The concept is similar to x = x + 1. You are just updating the variable with the result of an equation containing the variable. The result displayed in the message box is:

\\ComputerName\C$\filename

I suppose you could create a second variable to hold the result, but the following shows the same output.

Private Sub Command1_Click()
    Dim strTest As String
    strTest = "c:\filename"
    MsgBox "\\ComputerName\C$" & Mid$(strTest, 3, Len(strTest))
End Sub

It's just an example to show that you can use the Mid$ function to drop off the first 2 positions of the filename contained in strTest.

[Edited by jbart on 11-10-2000 at 12:49 PM]