VBA References (How to assign/unassign them)
VBA References (How to assign/unassign them)
(OP)
I have a very sophisticated Excel application that utilizes list boxes, common dialogs, etc. The result is it has a series of references to various dll's.Such as VB for Applications,Excel 10.0 Object Lib, OLE Automation, Office 10. Lib, MS Shell Controls and Automation. When I run this sheet on certain workstations it invariably ends up with a missing reference. This causes a runtime error and the VBA debugger opens, usually on a varibale declaration. If I then access the projects references it shows me which one is missing and I deselect it. Close the debugger and the program runs fine from then on. How on earth can it fail with the abscence of a reference and then run after deselecting the reference. It appears to me it never needed the reference in the first place. Can someone get me right on the references. How do you know what you should have? Can you prescan as the workbook is loading for what is needed and warn if the referenced dll is not present? Or this my re-introduction to dll hell?
Guy
Guy
Guy Edkins
Managing Partner
Delta Group Ltd
www.deltagl.com





RE: VBA References (How to assign/unassign them)
RE: VBA References (How to assign/unassign them)
The solution is to pre-compile your project. Only include in the project those references necessary for an error-free compile.
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
RE: VBA References (How to assign/unassign them)
If we can compile with VBA, how do we do it and will the code stand alone?
RE: VBA References (How to assign/unassign them)
Guy Edkins
Managing Partner
Delta Group Ltd
www.deltagl.com
RE: VBA References (How to assign/unassign them)
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein