View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Problem finding vbModal on users PC

In Excel 97, useforms could only be shown as modal, so the Show command did
not take an argument . I suspect this is your problem.

If you are not using modeless userforms, then modal is the default, so you
can just remove the argument. If you are, then you are in trouble.

--
Regards,
Tom Ogilvy



"Mark Desrosiers" wrote in message
...
Hello:

I've developed an Excel spreadsheet VBA program to
download some data and produce a report. It works fine on
my Windows XP system with Excel 2000. Just discovered the
user bas older equipment running Windows NT with Office 97
(gulp!). The first thing I see when the spreadsheet pgm
runs is a line of my code higlighting vbModal with the
message "Can't Find Project or Library".

Is it possible her Office 97 was loaded without some
(optional?) VB extensions? Is there an easy way to link to
the library from my VBA program? I believe I need
advapi32.dll.

Thanks,
Mark