XL98: Options on GetSaveAsFilename Dialog Box Not Returned

ID: Q184584


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


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:

Q183750 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:

Q176476 OFF: Office Assistant Not Answering Visual Basic Questions

Additional query words: XL98

Keywords : kbdta xlvbainfo OffVBA
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb


Last Reviewed: November 4, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.