Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel FileSaveAs dialog freezes when used via automation from Access
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automation to Excel from Access | Excel Discussion (Misc queries) | |||
Turn off printing status dialog with Excel automation | Excel Programming | |||
Automation between Access and Excel | Excel Programming | |||
Access Automation to Excel | Excel Programming | |||
Automation Excel & Access | Excel Programming |