Tom,
Disregard my previous post. This method worked perfectly.

Thank you very much,
Raul

"Raul" wrote:

> Tom,
> This isn't working, but I'm pretty sure the reason is the virus
> warning/"would you like to open this file" pop up. Is there a way to get
> around this?
>
> Thanks,
> Raul
>
> "Tom Ogilvy" wrote:
>
> > try
> >
> > sStr = "http://company/site/area/Production%20Data/PRODdata2005-2006.xls"
> > workbooks.open sStr
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "Raul" <raul@nothere.com> wrote in message
> > news:1AA94E23-523B-48CD-BB65-8EC1AA70107D@microsoft.com...
> > > I have been using Workbooks.Open "path....." to open a workbook, but now I
> > > need to be able to open a workbook in a portal database. Can anyone tell
> > me
> > > how to go about doing this?
> > >
> > > The old way: Workbooks.Open
> > > "P:\MODULE\Area\REPORTS\ProductionData\PRODdata0506.xls"
> > >
> > > New URL:
> > > "http://company/site/area/Production%20Data/PRODdata2005-2006.xls"
> > >
> > > Thanks in Advance,
> > > Raul
> > >
> >
> >
> >