Access VBA: Problem at saving an Excel file
 

hi Excel-freaks,

in MS Access, I generate an Excel file where the user should have the
possibility to determine the excel file name by file dialog. so I use
the following command:

xlapp.Dialogs(xlDialogSaveAs).Show
(xlapp being Excel.Application)

just at this point the Access Application stops and must be cancelled
by the task manager.Only after cancelling Access, the file dialog
appears and miraculously the saving action succeeds.
What is wrong here? why does Access stop?

thanx for your help, Helmut

Access VBA: Problem at saving an Excel file
 

Hi Helmut
Not too sure but maybe:
xlapp.IgnoreRemoteRequests = False
HTH
Cordially
Pascal

"Helmut Blass" a écrit dans le message de
om...
hi Excel-freaks,

in MS Access, I generate an Excel file where the user should have the
possibility to determine the excel file name by file dialog. so I use
the following command:

xlapp.Dialogs(xlDialogSaveAs).Show
(xlapp being Excel.Application)

just at this point the Access Application stops and must be cancelled
by the task manager.Only after cancelling Access, the file dialog
appears and miraculously the saving action succeeds.
What is wrong here? why does Access stop?

thanx for your help, Helmut