justdriving
09-10-2011, 04:23 AM
I need help to correct this code:-
Sub drl()
If Cells(65536.256).Value Is Nothing Then
DriveL = InputBox("Please specify your Drive Alphabet where File exists: ", "JustDrivingSoft", "C")
Cells(65536, 256).Value = DriveL
Else
DriveL = Cells(65536, 256).Value
End If
End Sub
Is there a permanent way, that even after closing file, my program will remember the Drive Letter input by me? It will not ask again through Inputbox.
Sub drl()
If Cells(65536.256).Value Is Nothing Then
DriveL = InputBox("Please specify your Drive Alphabet where File exists: ", "JustDrivingSoft", "C")
Cells(65536, 256).Value = DriveL
Else
DriveL = Cells(65536, 256).Value
End If
End Sub
Is there a permanent way, that even after closing file, my program will remember the Drive Letter input by me? It will not ask again through Inputbox.