Excel 97 Visual basic problem 
Author Message
 Excel 97 Visual basic problem

I've just installed excel97 from office 97 standard on my machine at home.
Initially I had the pro version but wanted to have the same version as at
work which is 97 standard so I uninstalled the pro version and installed the
standard version to find many of my excel files don't work. The error
message reads "Could not register visual basic environment please run setup"
then " An error occured inializing VBA libraries (1157)"
It also appears that I cannot run any macros or create them. This also
applies to word97

Please help!



Wed, 18 Jun 1902 08:00:00 GMT  
 Excel 97 Visual basic problem
Peter

Try running set-up again, but take either the full install, or the custom
options.  XL under standard install, does not in stall everything, although
it does install the ability to record macro's I think.

There is no difference between the applications themselves between Office 97
standard and pro, just the applications contained in the pack.  (I think
Access was bundled with pro).

If you are installing XL97, you should ensure you install SR1 & 2.  If your
XL was a later version, you could find it is SR1 anyhow.  (I think it says
on the CD, but it certainly will in Window>About Excel...).

If this doesn't work, I would suggest you un-install and run OffClean from
the 97 CD.  It should clear all traces of the installation and you can start
from scratch.

--
HTH

Nick Hodge
Microsoft MVP - [Excel]
Southampton, England



Quote:
> I've just installed excel97 from office 97 standard on my machine at home.
> Initially I had the pro version but wanted to have the same version as at
> work which is 97 standard so I uninstalled the pro version and installed
the
> standard version to find many of my excel files don't work. The error
> message reads "Could not register visual basic environment please run
setup"
> then " An error occured inializing VBA libraries (1157)"
> It also appears that I cannot run any macros or create them. This also
> applies to word97

> Please help!



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. DAO & Excel 97/Visual Basic problem

2. WANTED: Excel-Visual Basic for Applications Wanted: Excel-Visual Basic for applications Programmer - Ottawa

3. Problems with entering decimal values into excel 97 with Visual Basic

4. Problems Using Page Breaks in Excel 97 from Visual Basic

5. Problems Adding Page Breaks in Excel 97 using Visual Basic

6. Problems Using Page Breaks in Excel 97 from Visual Basic

7. Problems Adding Page Breaks in Excel 97 using Visual Basic

8. Converting and Excel Visual Basic File to an Access Visual Basic

9. Visual basic in Excel 97 part of Office 97

10. Macros - Need Visual Basic Help using Excel 97


 
Powered by phpBB® Forum Software © phpBB Group