I have a project which has the VBA Project Properties as follows:Project Name...............ChemistryUnit1Project Description.......Chemistry U1 Morning Report GeneratorIn the project, I have a variable that can change the Unit from 1 to 15.
I would like to automate the updating of the Project Properties using VBA code from within the same project, instead of manually updating the properties each time.
I have never modified VBA from within itself, I need help please.
What application are you talking about? Excel doesn't have any "project" properties. Is this a Microsoft Project question? Please be specific about where you can see the Project Name and Project Description and how you are accessing them in VBA code.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Hello PosseJohn,
You can change the VBA Project Description at runtime but not the project Name.
Change the PVBA Project Name
I believe the VBA Project Name can only be changed during Design time.
ThisWorkbook.VBProject.Description = "Chemistry U2 Morning Report Generator"
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I am in the project currently.
I have tried
Neither statement functions.MsgBox ThisWorkbook.VBProject.Description MsgBox ThisWorkbook.VBProject.Name
Hello PosseJohn,
Has the workbook been saved?
Leith,
Yes, the WB has been saved. I receive the following error message:
Programmatic access to Visual Basic Project is not trusted
Hello PosseJohn,
You will need to change your Trust Center settings to allow access to the VBA Project.
View my options and settings in the Trust Center
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
PosseJohn 
Register To Reply
Bookmarks