Article ID: 184584
Article Last Modified on 9/11/2002
APPLIES TO
- Microsoft Excel 98 for Macintosh
This article was previously published under Q184584
SYMPTOMS
When you display the Save As dialog box by using the GetSaveAsFilename method, changes that the user makes to the Save As dialog box may not be returned to Microsoft Visual Basic for Applications.
CAUSE
The Save As dialog box displayed from the GetSaveAsFilename method can only return the file name to Visual Basic.
STATUS
This behavior is by design of Microsoft Excel 98.
MORE INFORMATION
The dialog box displayed by the GetSaveAsFilename method contains a drop- down list that displays various file formats. It also contains an Options button that displays a dialog box containing save options. It is not possible to determine how the user has set these options with the GetSaveAsFilename method. For additional information, please see the following article in the Microsoft Knowledge Base:
183750 GetSaveAsFileName Method Arguments Are Ignored
REFERENCES
For more information about the GetSaveAsFilename method, click the Office Assistant, type GetSaveAsFilename Method, click Search, and then click to view "GetSaveAsFilename Method."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:
176476 OFF: Office Assistant Not Answering Visual Basic Questions
Additional query words: XL98
Keywords: kbprb KB184584