Gettin File name in macro

[redf1re]

Hi... is it possible by macro to know its file name??? something like
variable receaving "teste.xls" as valu

 

[Nick Hodge]

Something like

Sub GetWorkbookName()
Dim wbName As String
wbName = ActiveWorkbook.Name
MsgBox wbName & ".xls"
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Dave Peterson]

You can get it via:

activeworkbook.name
activeworkbook.fullname
and maybe you'd want
activeworkbook.path

..fullname will include the path. .Path will just give the path.

But both .name and .fullname will include any extension (if the file was saved
with an extension).

 

[redf1re]

thanx all