Problem opening a sheet with macros

  • Thread starter Thread starter Jakob
  • Start date Start date
J

Jakob

Hi
I have a excel 2000 sheet that has a macro and a visual
basic script in it, it is collecting info from a AS400
system. I installed sp4 for for w2k and all office sp's
and patches and after that I get the error: Microsoft
Visual basic "Error in loading DLL" when opening the excel
sheet.

All help is much appreciated

Regards
Jakob
 
Jakob...

for example purposes, here's a bit of code that includes
running a macro which is on a *.dll

If Run([FuncDelete], ShFunctions.Range("A2:Z20")) = -1
Then ExecuteExcel4Macro "UNREGISTER(""" & Me.Path
& "\FunCustomize.dll" & """)"

just to test I changed the name of this dll and then open
Xl, I got an error message on the dll loading, dll not
found.

Maybe with all the actulizations you lost a dll and the
code in your book is calling it.

After my test,, my book opened OK, it just didn't do what
it was supposed to... so maybe once your in you can hit
ALT+F11 and check the projects in your book in search for
a dll call, and then search your computer for that dll.

Thats all i have... cheers. JUAN
 
Back
Top