Change Directory on Workbook Open?

[paulked]

Am I missing something here?


Private Sub Workbook_Open()
Dim DefDir As String
MsgBox ("Make sure the Clock and Calendar are set correctly or the Boat Data will be INCORRECT")
DefDir = "C:\ovens\records\"
FileSystem.ChDir (DefDir)
End Sub


The directory is not changing from the directory where the file is opened from :dunno

I've tried using ChDir (DefDir) but that doesn't work either:dunno

What am I doing wrong?

Best regards

Paul Ked

[paulked]

Yes, I was missing the ChDrive command as I was opening the file from a Jump-Drive (G:\)
:blush