View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
papou papou is offline
external usenet poster
 
Posts: 110
Default 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