names not working after opening programmatically

[VerlindenG]

Excel2010 - OfficeXP and Office2010
I have a pretty big workbook with much names defined and used in it.
When I do open this workbook manually, no problem.
But when I open the workbook in VBA (Workbooks.Open (Filename) not one of the names seems to be recognised: every formala referencing a name gives the "#NAME?" error.

- Recalculating doesn't help.
- When I trie creating a new workbook with names, I do not have the same problem, but this is not really an option for the moment being because my actual workbook with the problem is huge.

Has anyone an idea how to get rid of this problem?

 

[drsarao]

Verlinden,
Welcome to Board.
Posting the problem code snippet here would help.

 

[VerlindenG]

Thank you, sir.
This is (only) the problem code snippet:
Workbooks.Open Filename:=tempbronbest
The file opens normally, but with name-errors.
Opening same file in the menus: no problem.

Verlinden,
Welcome to Board.
Posting the problem code snippet here would help.

 

[RoryA]

Are your names or the formulas using them using any add-ins or code?

 

[VerlindenG]

Well, some of them do, yes.
But, lots of them don't, and I do have the problem even with simple references (most of them to another page of the workbook)

 

[RoryA]

I do have the problem even with simple references (most of them to another page of the workbook)

Do the cells referred to contain #NAME error values? If so, they would propagate to the linked cells as #NAME errors too, even though the name in use was actually OK.

 

[VerlindenG]

No, absolutely not. The names refer to a page with rather "constant" values.

 

[RoryA]

And this affects every single formula that uses a name? Do other formulas work properly?

 

[VerlindenG]

as far as I saw, yes for your fist question, and yes for sure for your second.
When I remove a name out of a formula, the formula works again (but of course not as I wanted, because there's something missing now). When I put the name back in the formula, formula fails again.
(Only when I close and open the file again but manually, everything's fine. But I would like to open it in VBA. )

 

[RoryA]

Very strange. You aren't using any auto_open macros?