Rename 'VBAProject"

[Charlotte E.]

How to rename the current VBA-project by VBA-code?

You know, the name 'VBAProject', which each VBA-project is born with...


CE

 

[Tim Williams]

In the VB Editor, select the project in the tree then change the
(Name) entry in the Properties pane (press F4 if not showing)

Tim

 

[Charlotte E.]

Thanks for the answer, which I already knew, but I was asking how to to
it by VBA-code?


CE


Den 09.02.2012 19:53, Tim Williams skrev:

 

[Tim Williams]

Sorry - I misread your question

Tim

Thanks for the answer, which I already knew, but I was asking how to to
it by VBA-code?

CE

Den 09.02.2012 19:53, Tim Williams skrev:

 

[Tim Williams]

ThisWorkbook.VBProject.Name = "projTest"

See: http://www.cpearson.com/Excel/vbe.aspx

Tim

 

[Charlotte E.]

Thanks


CE



Den 10.02.2012 18:07, Tim Williams skrev: