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))"

--
Regards,
Tom Ogilvy


"Todd Huttenstine" wrote in message
...
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