I want to copy the active workbook name to a cell...

[trumb1mj]

I want to copy the active workbook name to a cell... I can display the activeworkbook using activeworkbook.name how can i display this in a cell?

[Don Guillett]

oh well.

Sub wb()
Range("a1") = ActiveWorkbook.Name
End Sub

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"trumb1mj" <trumb1mj.28mpsa_1149006907.1157@excelforum-nospam.com> wrote in
message news:trumb1mj.28mpsa_1149006907.1157@excelforum-nospam.com...
>
> I want to copy the active workbook name to a cell... I can display the
> activeworkbook using activeworkbook.name how can i display this in a
> cell?
>
>
> --
> trumb1mj
> ------------------------------------------------------------------------
> trumb1mj's Profile:
> http://www.excelforum.com/member.php...o&userid=34847
> View this thread: http://www.excelforum.com/showthread...hreadid=546779
>

[trumb1mj]

Thank you.