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

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

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

oh well.

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

--
Don Guillett
SalesAid Software

"trumb1mj" wrote in
message ...

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

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

Thank you.



:)


--
trumb1mj
------------------------------------------------------------------------
trumb1mj's Profile: http://www.excelforum.com/member.php...o&userid=34847
View this thread: http://www.excelforum.com/showthread...hreadid=546779