Workbooks.OpenText does not work on XP. HELP !!!

My Excel macro and textfile is located on a network drive. I hope this
helps.


Jake Marx wrote:
> Hi Rich,
>
> richmarin@earthlink.net wrote:
> > I got a "method OpenText of object Workbooks failed" runtime error.
> >
> > I saw similar posts to mine. But, I did not see a solution. Strange.
> > The command works in Excel 97. If I use the user interface and bring
> > in a text file in manually it works. But, Excel 2002 can not handle
> > OpenText.
> >
> > I don't know if the problem is XP or Excel 2002. And I need a solution
> > quick cause I am under a tight deadline.
>
> I tested your exact code in XL 2002 and XL 2003, and it worked in both
> places for me.
>
> Where is your text file located - on a local drive or on a network drive?
> How big is the text file (how many lines)?
>
> --
> Regards,
>
> Jake Marx
> MS MVP - Excel
> www.longhead.com
>
> [please keep replies in the newsgroup - email address unmonitored]

Rich,

richmarin@earthlink.net wrote:
> My Excel macro and textfile is located on a network drive. I hope this
> helps.

Does it work if either or both of the files are on a local drive?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]