I am trying to declare a constant which will hold the workbook name (Th
workbook running the macro that is).

So I am doing

Public Const WorkBookName As String = ThisWorkbook.name

First thing in Module 1 but I keep getting:

"Constant Expression Required"

How can I declare the constant with the workbooks name?

Best Regards

Noo

--
Message posted from http://www.ExcelForum.com