Hi,
I am trying to write VB code on the BeforeSave event to call a module that
was created by another developer. When I open the Enterprise Global,
navigate to VB Editor, and open the Project Explorer, the only items I see
are:
1) VBAProject (Project 1)
2) ProjectGlobal (Global.MPT)
3) VBAProject (Global(+non-cached Enterprise))
From the reading I have done, I believe that I should also have VBAProject
(Checked-out Enterprise Global), and this is where all enterprise code
should be written.
Why does that not show for me and how can I get it to? This is happening
in the Production and Test environment and much configuration has been
done to Project Server.
Thanks,
Kristen
Rod Gill wrote:
Hi,I got this as well and the legendry Gary Chefetz helped me out with
05-Jun-08
Hi,
I got this as well and the legendry Gary Chefetz helped me out with this:
----------------------------
What's happened in this case is that the VBA stream in the e-global has
become corrupted. There's no way to fix it without recreating away the
enterprise global. As far as recreating the e-global, if you need to you
can
see if you have one to restore from the archive db. If not, you can take
all
of your enterprise views, tables, filters, reports (the basic ones),
groups,
forms, maps and toolbars and move them to an MPP file. Next, you can run
the
SQL script that creates the e-global; the scripts are located in:
c:\Program Files\Microsoft Office Servers\12.0\Sql\Project
Server\CORE\1033
The script is named eglobal.sql. Do make sure you have a backup of things
before you run scripts. Once the e-global has been rebuilt, then you can
check it out, open your MPP file where you saved all of the elements and
then use the organizer to move everything back. Do note that unlike
Project
2003 where fields and calendars were stored in the e-global, they no
longer
are in 2007.
---------------------------
Apparently to avoid this problem if and when you have the e-global open,
don't try to close it without having saved it first
Luckily this happened on a pilot installation so I have added the VBA code
to all 12 PMs workstations since the server will be re-built for the next
phase. I have also added to Admin training "When you open the EGlobal
immediately save it in case you forget later!!
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
Previous Posts In This Thread:
Issue!! Calling VBA from Enterprise Global
Hi,
I'm using Project server 2007, i need to write codes in
VBAProject(Global(+non -catched enterprise). But, If i open the above
project
showing error "Error accessing file. Network connection may have been
lost".
I sure the connection is fine when opening the project professtional(this
is
admin user only).
Really facing this issue for long time, please suggest me !!
Thanks
Psk
Hi,You have to open the Enterprise Global itself and put the modules
there.
Hi,
You have to open the Enterprise Global itself and put the modules there.
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Actually while opening enterprise global itself showing the below
error"Error
Actually while opening enterprise global itself showing the below error
"Error accessing file. Network connection may have been lost", if i forced
to open it and went to vba editor, i m not able to write the script for
the
particualar VBAProject(+non -catched enterprise) showing the same error,
unable to see the coding window. i don't want to put the code in
"global.mpt", because that i can accessble.
What can i do ?
:
Hi,This must be a problem with your server installation.
Hi,
This must be a problem with your server installation.
An administrator must have read/write access to the Enterprise Global.
Have you tried the Server newsgroup?
This is not a development problem as such.
Hope this helps
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Hi, I have given a read/write permission to admin, thing is very first
time
Hi,
I have given a read/write permission to admin, thing is very first time
when i open the VBA through enterprise global, i can able to see all types
of
projects (enterprise global, -non+catched enterprise etc). after writing
the
code in -non+catched enterprise was working fine initially but once i
closed
all projects & PWA issue was arrised suddenly -non +catched enterprise is
gone. Then i have changed the "macro security as 'very low/medium' level "
i
can see the "non catched enterprise" but throwing the error while opening
project as we discused previous mail..
What can i do ? suggest me plz..
:
Hi,Can't you really write the code in a module in Enterprise global?
Hi,
Can't you really write the code in a module in Enterprise global?
Putting Macro Security to Low is indeed a very good idea
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Actually the "-non +catched enterprise" is under enterprise global only..
Actually the "-non +catched enterprise" is under enterprise global only..
In project explorer showing
1. Project Global(Global.mpt)
2. VBAProject(Global(+non-catched Enterprise)
3. VBAProject(here my project name)
..I wants to call the function module, if you open any of the projects.
function calling through Project_Open() event.
..If i write a code in above point 1. project in open() event..not calling
the function whenever opening the project.
..understand needs to write the code in above point 2. project in open()
event. but i am not able to open the coding window, error is showing
"Error
accessing file. Network connection may have been lost".
This is what i did, plz let me know the alternative ..
:
Hi,ToolsEnterprise OptionsOpen Enterprise GlobalThen in the projet
Hi,
Tools
Enterprise Options
Open Enterprise Global
Then in the projet explorer:
Global.mpt
E-global
VBAProject(Global(+non-catched Enterprise)
VBAProject(here my project name)
The modules must be ineserted in E-global.
Hope this helps
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Hi, I aware of the methods for getting the below module, but i'm not able
to
Hi,
I aware of the methods for getting the below module, but i'm not able to
write the code in "VBAProject(Global(+non-catched Enterprise)".
if i double click "ThisProject(Global(+non-catched Enterprise))",
it's showing error: "Error accessing file. Network connection may have
been
lost".
This is what the issue !!!
:
Hi,,You really, really, make me dispair.
Hi,,
You really, really, make me dispair.
You MUST NOT write in the Cached-Out enterprise, NOT, NOT.
I never never said that.
You must write in the Enterprise Global itself.
Do EXACTLY as I said in the previous mail and stop wondering about the
Cached-out Enterprise.
Hope this helps,
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Re: Issue!! Calling VBA from Enterprise Global
Thank's a lot..
:
You're very welcome!
You're very welcome!
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Hi,I've got the same problem. using MSP2007SP1. I can see the module.
Hi,
I've got the same problem. using MSP2007SP1.
I can see the module. cant open/edit the code. got the same error message.
have you been able to figure it out?
thanks,
Ido.
:
Re: Issue!! Calling VBA from Enterprise Global
Hi all
I had this problem as well
To solve it you have 3 options:
1. If you save your macros in your LOCAL E global file you just need to
delete it, off course you will lose your macros but it is better than
reinstall your farm.
2. Enter into the VBA editor and try to remove the modules
3. Install the farm again and export your E global and import it to your
production server.
Regards
:
Hi,I got this as well and the legendry Gary Chefetz helped me out with
Hi,
I got this as well and the legendry Gary Chefetz helped me out with this:
----------------------------
What's happened in this case is that the VBA stream in the e-global has
become corrupted. There's no way to fix it without recreating away the
enterprise global. As far as recreating the e-global, if you need to you
can
see if you have one to restore from the archive db. If not, you can take
all
of your enterprise views, tables, filters, reports (the basic ones),
groups,
forms, maps and toolbars and move them to an MPP file. Next, you can run
the
SQL script that creates the e-global; the scripts are located in:
c:\Program Files\Microsoft Office Servers\12.0\Sql\Project
Server\CORE\1033
The script is named eglobal.sql. Do make sure you have a backup of things
before you run scripts. Once the e-global has been rebuilt, then you can
check it out, open your MPP file where you saved all of the elements and
then use the organizer to move everything back. Do note that unlike
Project
2003 where fields and calendars were stored in the e-global, they no
longer
are in 2007.
---------------------------
Apparently to avoid this problem if and when you have the e-global open,
don't try to close it without having saved it first
Luckily this happened on a pilot installation so I have added the VBA code
to all 12 PMs workstations since the server will be re-built for the next
phase. I have also added to Admin training "When you open the EGlobal
immediately save it in case you forget later!!
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
Submitted via EggHeadCafe - Software Developer Portal of Choice
SQL Server Dynamic WHERE clause without exec
http://www.eggheadcafe.com/tutorial...1d-4ee20a205ab2/sql-server-dynamic-where.aspx
__________ Information from ESET Smart Security, version of virus
signature database 4697 (20091217) __________
The message was checked by ESET Smart Security.
http://www.eset.com
