General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel97 Application.Dialogs & strings
sTodaysDate = date formatted as MMDDYY earlier
sUserName = a user name I got earlier
sSaveFile = "PHO.QTE." & sTodaysDate & "." & sUserName
Application.Dialogs(xlDialogSaveAs).Show sSaveFile
The dialog box displays the sSaveFile string correctly in the file name box, but surrounds it with quotation marks. If I replace sSaveFile with some text, the quotes go away. How do I build the filename, and fill in the file name box, without quotation marks?
Thank you,
Ray