View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Marsh[_2_] Tim Marsh[_2_] is offline
external usenet poster
 
Posts: 14
Default Display Current File Name in MsgBox

never replied to a post before, so i hope i get this right: -

to include preceeding text, use concatenation, ie,

MsgBox "Some Text " & Application.ActiveWorkbook.name

"Paul Moles" wrote in message
...
It must be simple but I can't find how to display the
current filename in a message box, preceded by a piece of
text. eg. MsgBox

Cleared workbook has been saved as current filename.

The file has already been saved so the current filename is
available.

MsgBox Application.ActiveWorkbook.name gives the current
filename but I cannot find how to precede the name with a
meaningful message.

Many Thanks
Paul