Reply to thread

Message: [QUOTE="Nick H, post: 6454860"] Hi, we have an application that consists of a number of similar UI workbooks which all use the VBA code in a central Engine workbook (well, it's an AddIn but not installed client side). The users launch the UI files via links on a webserver and a UI's WorkbooOpen event launches the Engine from a different server - our production server. The Engine code is then accessed via 'Application.Run' statements. This works ok but I thought it would make development life easier if the UIs 'referenced' the engine so we didn't need to use the 'Application.Run' statements anymore and didn't have to check whether or not the Engine was already open when launching a UI. Referencing tests worked fine on our development server but as soon as I copy the new UI files to the Webserver and launch via the links the reference no longer works and I'm plagued with compile errors. Frustratingly, if I luanch the VBE to debug, the reference to the engine then starts to work. Is there some parameter that needs to set before referencing a networked workbook/AddIn will work properly from a webserver? Best regards, Nick. [/QUOTE]