| 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 | |||
![Charlotte E.[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
