Hi. I have the following code, but it doesn't seem to work. I get
the dialog box for Save As, but it is not bringing in the default
directory I have specified. Any idea what I am doing wrong? Thanks!

Sub test()

sStr = "C:\Documents and Settings\Files\workFiles\"
ChDrive sStr
ChDir sStr
On Error Resume Next
Application.Dialogs(xlDialogSaveAs).Show

End Sub