I have an MS Access 2000 database that uses COM automation to create a new
Excel workbook and transfers data to it and then call's the Excel workbook's
SaveAs dialog box so that the user can save the workbook in any format he
chooses (eg xls, csv etc).

When the user tries to save the workbook in the default folder specified in
the dialog box (My Documents) , everything goes smoothly. However, if he
tries to change the directory first, the dialog seems to freeze for about 15
seconds. If a button is pressed on the dialog, then a Switch to / Retry
error comes up.

I'm sure I've seen something similar before. Does anyone have a solution to
this problem?