In previous versions of Excel (pre-2007) I have been using -

Application .Dialogs(xlDialogOpen).Show([path variable here])

Under Excel 2007 the above code opens the 'My Documents/OfficeDocs' rather
than the path setup programatically. (I tried this hard-coded with the same
result.)

Is there some change in Excel 2007 that is causing this?

Thanks - jamie