Invalid procedure call or Argument (please help)

I have this code that was working to export all my tabs based of their names (which are variables)
Now i am getting an error code for "Invalid procedure call or argument"

What needs to change?

Please Login or Register  to view this content.

Do you get the error for every sheet?

So it's a compiler error? Which line is highlighted?

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

I am having a similar problem. "Invalid procedure call or argument" is runtime error 5. I have several files that are all made from the same template and only one of them causes this error. I inserted a line of code to use a short file name in case that was the problem but it still fails. In the case of the OP, length is not the issue since the path isn't too long and a sheet name cannot exceed 32 characters (one source says the full path name cannot exceed 281 characters, though I have not confirmed this).

There is no way to tell without the file but this error will occur if a sheet is not visible.