Out of Memory Problem

[Todd Huttenstine]

Sheets("Converted Data").Range("P2") = "=INDEX('[COGNOS
Followup Mismatches.xls]COGNOS Names'!$B:$B,MATCH
(N:N,'[COGNOS Followup Mismatches.xls]COGNOS Names'!
$A:$A,0))"

Hey guys the above code inserts an index formula into cell
P2. Everytime I run the code it asks me where COGNOS
Followup Mismatches.xls is located. I have to tell it
every time. Instead of having to do this, is there a way
I can put it in the code so it knows? It is located in...
Q:\Stats2004\Todds Reports\COGNOS Followup Mismatches.xls

Also when I navigate to it and click ok, I get the
error "Not Enough Memory". Why does this happen and how
do I fix this?


Thanks
Todd Huttenstine

 

[Tom Ogilvy]

Sheets("Converted Data").Range("P2") = "=INDEX('Q:\Stats2004\Todds
Reports\COGNOS [COGNOS
Followup Mismatches.xls]COGNOS Names'!$B:$B,MATCH
(N:N,'Q:\Stats2004\Todds Reports\COGNOS [COGNOS Followup
Mismatches.xls]COGNOS Names'!
$A:$A,0))"