VBA Error

[juan4412]

On my machine this code works:

.SaveAs Filename:="C:\Ricardo\mail\" & Format(Range("G3").Value) & ".xls"

But on anothers PC it highlights the word "Format" and says object or library not installed, but they have the same references installed as I do.

What is throwing this error?

 

[Colin Legg]

Okay, if it works when you qualify the functions with VBA. then I can think of only two things that might be wrong:

(1) You have another, custom function called Format(), which is causing confusion
(2) There's a problem with the "MISSING" references


Since the code works on your PC, (1) cannot be the problem. It must be (2).
All I can suggest it that you look through the references for any others that are "MISSING" , just to make sure they are all unticked.

If that isn't fruitful, then the fallback solution would be to prefix with VBA. This isn't ideal, I know. Hopefully someone else might think of a cause which I've overlooked.

 

[juan4412]

Thanks for all the assistance.

I ended up just prefixing VBA. and it is functioning on other pc's now.