"Expecting object to be local"

[gerrardhickson]

Hi All,

Some time back (years ago) I started getting a new error message when debugging code - that error is "Expecting object to be local".  I usually find that I've done something wrong, but the error message doesn't seem to help or offer any clues as to what the error might be. Some longer time ago, this message didn't seem to exist (at least, I didn't get it).

What does it mean? what should I be looking for when I get it? 

Searching the forums doesn't yield any results - it seems to be unique to me somehow.

Any suggestions?

EDIT: I just resolved the error above by saving my assembly document. Go figure...

EDIT 2 : Moments later, I get the same error - but this time it's because I had 'NewAssy' in my replace function, instead of a filename string. 

[bradeneuropeArthur]

Use this:

NewAssy.FileName

(The "." "Dot" is missing in your code)

[gerrardhickson]

No, NewAssyFileName is declared as a string further up the code. I cropped most of it out because I'm not looking for debug help. In trying to understand how what this error message means.

In my edits, I was getting the same error for two very different problems. 1) I needed to save the working files and 2) I used an object where I should have used a string.

I'll share some code when I'm back in the office. I expect that other users will get a different error message to what I'm seeing.

[bradeneuropeArthur]

https://learn.microsoft.com/en-us/office/troubleshoot/excel/run-time-error-2147467259-80004005

[gerrardhickson]

Yeah, I've googled it too. The results aren't particularly helpful.

[gerrardhickson]

I think I've narrowed the problem down to a PC configuration.  I'm messing around with more code this morning on a different machine - then I transferred the code to my main machine to continue working on it, and I got errors on the same line, but the errors are different.

Any suggestions?