I have developed an application that runs well on my Local XP machine running Office 2007. We want to move this application to an application server, so that multiple users can access it. We also need to access it through Citrix as we have a number of MAC users, but that issue is for later.
Right now, in just trying to compile the code in 2008, it errors out on statements that have [variable]'s around them. The error mostly seen is: Can't find the Project or Library. There were a couple of MISSING References, but I added those in. To further check out the issue, those MISSING references were unchecked in the XP machine, restarted, recompiled, and it seems they weren't needed as it compiled with no errors.
Server 2008 is 64 bit, but the application is being run on Excel from the x86 folder in Program Files.
What other areas need to be checked so that, the Evaluate [...]'s and other functions such as:
Private Function TransparentUserForm(frm As UserForm, Level As Byte) As Boolean
will work properly?