Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Issue!! Calling VBA from Enterprise Global

88 views
Skip to first unread message

Psk

unread,
Mar 28, 2008, 7:33:00 AM3/28/08
to
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

Jan De Messemaeker

unread,
Mar 28, 2008, 8:30:01 AM3/28/08
to
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
"Psk" <P...@discussions.microsoft.com> wrote in message
news:2F437FCC-694F-45DF...@microsoft.com...

Psk

unread,
Mar 28, 2008, 8:47:02 AM3/28/08
to
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 ?

Jan De Messemaeker

unread,
Mar 28, 2008, 9:10:05 AM3/28/08
to
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
"Psk" <P...@discussions.microsoft.com> wrote in message

news:409E803A-4709-44A3...@microsoft.com...

Psk

unread,
Mar 31, 2008, 2:46:01 AM3/31/08
to
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..

Jan De Messemaeker

unread,
Mar 31, 2008, 3:45:39 AM3/31/08
to
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
"Psk" <P...@discussions.microsoft.com> wrote in message

news:9C350D15-AC8E-4252...@microsoft.com...

Psk

unread,
Mar 31, 2008, 4:59:00 AM3/31/08
to
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 ..

Jan De Messemaeker

unread,
Mar 31, 2008, 8:13:17 AM3/31/08
to
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
"Psk" <P...@discussions.microsoft.com> wrote in message

news:AA5BFBD0-9988-49DE...@microsoft.com...

Psk

unread,
Mar 31, 2008, 9:37:00 AM3/31/08
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 !!!

Jan De Messemaeker

unread,
Mar 31, 2008, 10:07:04 AM3/31/08
to
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
"Psk" <P...@discussions.microsoft.com> wrote in message

news:C44E8D87-24CB-4788...@microsoft.com...

Psk

unread,
Apr 1, 2008, 9:25:00 AM4/1/08
to
Thank's a lot..

Jan De Messemaeker

unread,
Apr 1, 2008, 10:57:01 AM4/1/08
to
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
"Psk" <P...@discussions.microsoft.com> wrote in message

news:CBE8D906-1FD9-4AF4...@microsoft.com...

Ido Stein

unread,
May 21, 2008, 5:44:04 AM5/21/08
to
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.

ארז‎

unread,
Jun 5, 2008, 9:56:08 AM6/5/08
to
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

Rod Gill

unread,
Jun 5, 2008, 3:47:46 PM6/5/08
to
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

"Psk" <P...@discussions.microsoft.com> wrote in message

news:C44E8D87-24CB-4788...@microsoft.com...

kb

unread,
Dec 17, 2009, 1:45:23 PM12/17/09
to
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,

---------------------------

--

Previous Posts In This Thread:

On Friday, March 28, 2008 7:33 AM
Ps wrote:

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

On Friday, March 28, 2008 8:30 AM
Jan De Messemaeker wrote:

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
"Psk" <P...@discussions.microsoft.com> wrote in message
news:2F437FCC-694F-45DF...@microsoft.com...

On Friday, March 28, 2008 8:47 AM
Ps wrote:

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 ?


"Jan De Messemaeker" wrote:

On Friday, March 28, 2008 9:10 AM
Jan De Messemaeker wrote:

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
"Psk" <P...@discussions.microsoft.com> wrote in message
news:409E803A-4709-44A3...@microsoft.com...

On Monday, March 31, 2008 2:46 AM
Ps wrote:

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

"Jan De Messemaeker" wrote:

On Monday, March 31, 2008 3:45 AM
Jan De Messemaeker wrote:

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
"Psk" <P...@discussions.microsoft.com> wrote in message
news:9C350D15-AC8E-4252...@microsoft.com...

On Monday, March 31, 2008 4:59 AM
Ps wrote:

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

"Jan De Messemaeker" wrote:

On Monday, March 31, 2008 8:13 AM
Jan De Messemaeker wrote:

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
"Psk" <P...@discussions.microsoft.com> wrote in message
news:AA5BFBD0-9988-49DE...@microsoft.com...

On Monday, March 31, 2008 9:37 AM
Ps wrote:

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


"Jan De Messemaeker" wrote:

On Monday, March 31, 2008 10:07 AM
Jan De Messemaeker wrote:

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
"Psk" <P...@discussions.microsoft.com> wrote in message

news:C44E8D87-24CB-4788...@microsoft.com...

On Tuesday, April 01, 2008 9:25 AM
Ps wrote:

Re: Issue!! Calling VBA from Enterprise Global
Thank's a lot..

"Jan De Messemaeker" wrote:

On Tuesday, April 01, 2008 10:57 AM
Jan De Messemaeker wrote:

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

On Wednesday, May 21, 2008 5:44 AM
ido wrote:

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.

"Jan De Messemaeker" wrote:

On Thursday, June 05, 2008 9:56 AM
@discussions.microsoft.com wrote:

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

"Ido Stein" wrote:

On Thursday, June 05, 2008 3:47 PM
Rod Gill wrote:

Hi,I got this as well and the legendry Gary Chefetz helped me out with
Hi,

---------------------------

--


Submitted via EggHeadCafe - Software Developer Portal of Choice
SQL Server Dynamic WHERE clause without exec
http://www.eggheadcafe.com/tutorials/aspnet/63eb37b5-8539-40fc-8f1d-4ee20a205ab2/sql-server-dynamic-where.aspx

Rod Gill

unread,
Dec 18, 2009, 3:23:26 AM12/18/09
to
You need to open the Enterprise Global. Note that for safety you should
immediately save the Global as there is an old bug that corrupts the file if
closed without saving. I can't remember if this has been fixed by recent
updates.

Best (and safest) practice is to get all code working then copy to the E
Global.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com


"K B" wrote in message news:20091217134518kr...@rcmt.com...

> __________ Information from ESET Smart Security, version of virus
> signature database 4697 (20091217) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4697 (20091217) __________

The message was checked by ESET Smart Security.

http://www.eset.com

0 new messages