Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
shancock  
#1 Posted : Saturday, October 16, 2010 2:19:16 AM(UTC)
shancock
Rank: Newbie

Reputation:

Groups: Registered
Posts: 0
Location: Perth

When creating a chemistry output table one of following ESdat error boxes appear:

When producing the summary statistics:

 20 Cannot run the macro "RunStatCalcs". The macro may not be available in this workbook or all macros may be disabled.

When auto formating the environmental guidelines :

 1440 Cannot run the macro "FormatChemTableNumbers". The macro may not be available in this workbook or all macros may be disabled.

Is this a ESdat related error, or an issue with excel?  I have changed the macro security on excel to enable all macros, all controls without restrictions and all data connections. I suspect it is an issue with either the macro or visual basic available memory or passwords enabled on the macros.

Has any one else had this issue?

 

 

Warwick Wood  
#2 Posted : Saturday, October 16, 2010 3:52:42 AM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hello,

We have seen that a few times.  If you uninstall ESdat, ensure the installation directory is clean (ie c:\Program Files\ESdat) and re-install that should fix it.  Make sure Excel is closed.

 REgards,

 Warwick

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.