| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extra Quote Mark
CODE
fname = "ChkDigitsSent" & Format(Now(), "mm") & Format(Now(), "dd") & Format(Now(), "yy") & ".xls" MsgBox fname ' There is no quote mark displayed here ans = MsgBox("Do you want to save a copy of the file as: " & Chr$(10) & Chr$(34) & fname, vbYesNo + vbQuestion, "Create Copy?") ' There IS a quote mark displayed here (see below) QUESTION I'd like to know where the quote mark is coming from as is generated by the code above. MESSAGE BOX Do you want to save a copy of the file as: "ChkDigitsSent013005.xls |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stray mark causing extra page to Print | Excel Discussion (Misc queries) | |||
| Foot mark aka single quote mark? | Excel Worksheet Functions | |||
| How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
| Help - 'finding' a quote mark (") ??? | Excel Programming | |||
| Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! | Excel Programming | |||
Threaded Mode
