Does no one have an answer to this?

[Francis Hookham]

The speed with which answers are provided here is amazing but I posted this
a week ago and I hoped to hear by now! Or haven't I made the problem clear?

Following a problem with my G4 I reinitialised it and loaded OS 10.3.9 and
Office 2004 and everything else from scratch

An important 10 sheet 892KB XL file, which I have built up over many years,
has many macros and has crossed from Mac to Pc and back again with no
problem

It still does between iBook (OS 10.3.9) and XL v, X (Microsoft Excel for Mac
Service Release 2)

Now on the G4 this, and other XL files will not run, showing the message
'Error in loading DLL'. Nor can I write a macro in a blank sheet ­ Unable to
record¹ although I have checked VB is installed

Trying to open the Visual Basic Editor results in ŒCan¹t load Visual Basic
for Applications¹

Word is similar ­ ŒThe macro could not be created¹ and ŒCould not open macro
storage¹

Disastrous! Please help

Impatient Francis Hookham

 

[LRL]

I've just started Excel VBA development but I do move workbooks with
macros back and forth between platforms so let me see if I can try a
few things.

Since it runs on an iBook but not the on G4 leads me to believe that
the workbook is fine. The fact that Word on the G4 is also having
trouble with macros lends credence to the proposition that Office
itself is broken not the workbook.

So, an obvious if ugly possible solution is to uninstall Office, then
reinstall Office. Run all the necessary updates to office and give the
WB a shot.

You can try the Fix Permissions voodoo via Disk Utility just in case
something messed with your ability to access important files. It's
worth a try before the uninstall/install route.

I'm going to assume that you've rebooted the system between attempts.

Hope this helps.

 

[Jim Gordon]

Hi Francis,

Is it possible that you did a custom install and left out the Visual
Basic elements? It almost sounds like it.

If you have not used Disk Utility to Repair Permissions, try that first.

-Jim