Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem finding vbModal on users PC
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow users to edit ranges problem 2007 | Excel Discussion (Misc queries) | |||
sharing excel sheet with multiple users, but other users cant see | Excel Discussion (Misc queries) | |||
Problem with multiple users opening a workbook | Excel Discussion (Misc queries) | |||
Finding the solution to an Exel problem. | Excel Worksheet Functions | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |