Display Current File Name in MsgBox
dim title as string
dim msg as string
title = "File Loaded"
msg = "The following workbook is saved" & vbcr & vbcr
msg = msg & ActiveWorkbook.name
msgbox msg,,title
Patrick Molloy
Microsoft Excel MVP
-----Original 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
.
|