Quote:
Originally posted by kenji4861
I'm having the same problem.
This problem does occur if the file does not exist, but it also happens on bigger files. Also seems to occur less on the PC, but occurs more on the Mac.. (I'm using this on Excel).
|
I finally found the problem I had. My macro made a request to a database, then I wanted to report the result in Excel. The problem was that some data began by char like '-', '+' or '=' which are interpreted as functions in Excel. I just corrected it by adding a ''' at the begining of each string having these char at first.
In fact, this error can have many reasons. It's not a very accurate message... Something like a dummy error. One more time thanks Bill!