Error Message [SOLVED]

[Bomino]

Hello,
I need some experts advise. I have a code that is "acting up". When I run in my project it is giving me an error message as shown below:


But when I tested it in another workbook it works just fine. See attached file. I also have a screen shot of the error message in the attached file.
Could someone please help fix this issue?
Thanks.

 

[prasaddn]

Hi.

The Format() function is part of VBA library. In your system where this error is coming if you try VBA.format( instead of just Format it will work.

A lot of string functions, vba functions works without prefix of vba like left(), right(), len() etc, but if you get the same error, then you need to specify vba.left(), vba.right() etc.

the other option to solve is I believe is to add this library file VBE6.dll to your project. In my system it is at below path. Not sure if it is going to be same for all systems:
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL

Regards,
Prasad DN

 

[Bomino]

Thanks for your prompt response, Prasaddn. I will give this a shoot.
I really don't understand why it is NOT working in my project but it IS working when I use the code in a different workbook; on the SAME machine....

 

[Bomino]

It works!! Thanks a lot Prasaddn.