VBA dot required to use function

[Bowermml]

I have a users machine that won't run the Excel vba functions, such as left or environ (or maybe all vba functions) without explicitly prefacing it with VBA. (vba dot).

Just this machine right now. I have never seen this before. I don't want to have to go back through the code and preface every function with vba dot.

Does anyone know why this would occur?

 

[My Aswer Is This]

Show us your script

 

[Norie]

Have a look under Tools>References... on the user's machine and see if anything checked that is also marked as MISSING.

If there is anything note it's name, uncheck it, save and close the file, reopen it and try the code again.

 

[Bowermml]

Show us your script

It happens even in a blankworsheet with one f(x), such as

test sub

debug.print environ("username")

end sub

 

[Bowermml]

I think that might be it. There was a reference to a missing ocx that I thought I resolved in my install script, but now I am thinking I didn't. I will let you know when I have access to the user's machine in the morning.

 

[Bowermml]

Sorry for the delayed update. The problem was a broken reference. It was an old 32 bit .dll that had to be removed from Excel to make it compatible for 32 and 64 bit Office. Even though I removed the reference and it worked on my test machine, the reference was somehow staying alive. When the file got passed around to other machines, it was causing the issue. I can't remember exactly what I did, but it was something along the lines of adding and removing the 32 bit reference multiple times before it went away. Once the reference went away, so did the problem.

 

[Bowermml]

OCX, not dll