[EXCEL] problem running macro on different computers

[alibababags]

hey all,

basically I've encountered a problem in my office. I've received a macro worksheet from my colleague to run some functions.

it runs perfectly fine on another colleague's computer but when i run it on my computer and another colleague's the macro doesn't function as well, meaning that it does not compute all the data and i'm left with a #REF in the column where the datas are supposed to appear.

I've double checked the code but it there doesn't seem to be any changes and i've also checked the security code and library references and we have all the same references checked.

am at my wits end not

thanks in advance for your help!

 

[peterchan75]

Usually, one uses Excel macro to do something by taking input and output something. If the Excel spreadsheet and the macro code remain the same, then I would suspect that your input is causing the problem. E.g. the macro is not able to handle your input condition.

 

[alibababags]

Usually, one uses Excel macro to do something by taking input and output something. If the Excel spreadsheet and the macro code remain the same, then I would suspect that your input is causing the problem. E.g. the macro is not able to handle your input condition.

thanks for the reply!

its strange because all conditions are met and fixed. the inputs are also the same we only have to enter the input in one column and let the macro run.

both my colleagues entered the same input. one can run the other cant

 

[ykgoh]

Check if your Office is 32 bit or 64 bit. I vaguely remember that some VBA macros may not work properly on 64 bit Excel, that's why Microsoft recommends most users to install the 32 bit Office even on 64 bit Windows for compatibility reason.

Also, does the macros depends on some Excel add-on, or ActiveX controls? Again, some of these third party software, especially older ones, may not have 64 bit version.

 

[peterchan75]

I myself is using Excel 2007 so it's definitely 32bit. As per ykgoh, it may be a 64bit issue. If you have access to the macro code, then you can go the Microsoft Visual Editor from View Macro and step through the code by clicking the left legend of the macro editor and a maroon dot will appear. Click the run button and it hits the pause line, it will turn yellow. Go to the next line that you intend to pause and click on the left legend. You can remove the pause by click on the maroon button again. During each pause, you can check your spreadsheet and see whether the REF error appears. Hope that you can catch the buggy code.