Rename 'VBAProject"
 

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

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


CE

Rename 'VBAProject"
 

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


On Feb 9, 9:03*am, "Charlotte E." wrote:
How to rename the current VBA-project by VBA-code?

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

CE

Rename 'VBAProject"
 

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:
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


On Feb 9, 9:03 am, "Charlotte wrote:
How to rename the current VBA-project by VBA-code?

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

CE

Rename 'VBAProject"
 

Sorry - I misread your question

Tim

On Feb 10, 3:35*am, "Charlotte E." wrote:
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:







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

On Feb 9, 9:03 am, "Charlotte *wrote:
How to rename the current VBA-project by VBA-code?

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

CE

Rename 'VBAProject"
 

ThisWorkbook.VBProject.Name = "projTest"

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

Tim

On Feb 9, 9:03*am, "Charlotte E." wrote:
How to rename the current VBA-project by VBA-code?

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

CE

Rename 'VBAProject"
 

Thanks :-)


CE



Den 10.02.2012 18:07, Tim Williams skrev:

ThisWorkbook.VBProject.Name = "projTest"

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

Tim

On Feb 9, 9:03 am, "Charlotte wrote:
How to rename the current VBA-project by VBA-code?

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

CE