Excel Macro and WinNT Workstation

We run a set of macros in Excel as a part of our end of day process. I’ve created a user that can log on to the machine and do my job when I’m on vacation. The macro, however, doesn’t run correctly. The same exact macro runs fine under my user name.I created the new user by copying my user. I’ve installed the Excel Add-Ins but I still get Run-time Error 9, Subscript Out of Range. Any ideas?