Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listen to "rename sheet" event in excel | Excel Programming | |||
How to listen to "rename sheet" | Excel Programming | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
How to rename worksheet like "Jan. 2006" | Excel Programming | |||
How to use macro to rename worksheet with date +"text" | Excel Programming |