On another forum I was asked how to set the default directory when using Application.Dialogs(xlDialogSaveAs).

Simple one, I thought, I opened a new file and tried 
Dim Mystr As String
Mystr = "C:\PTL Files"
ChDrive "c:\"
ChDir Mystr
Application.Dialogs(xlDialogSaveAs).Show Mystr
and it worked fine. The OP wrote back and said it didn't work - I tried my code again and he was correct. After going through google I discovered that this code works fine for Excel 97 but not later versions. On my own accord I also confirmed that it worked fine on unsaved files

Several recent links suggest that it should work in later Excel versions, ie
Here
Here 2

Has anyone else come accross this?

Cheers

Dave