| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Saving Excel File as PRN | Excel Discussion (Misc queries) | |||
| MS-Excel VBA file (XLA) saving problem | Setting up and Configuration of Excel | |||
| problem saving csv file | Excel Discussion (Misc queries) | |||
| problem saving excel file on a network | Excel Discussion (Misc queries) | |||
| Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Threaded Mode
