Thread: Open Workbook using URL instead of network path
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Open Workbook using URL instead of network path
try

sStr = "http://company/site/area/Production%20Data/PRODdata2005-2006.xls"
workbooks.open sStr

--
Regards,
Tom Ogilvy


"Raul" wrote in message
...
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\PRODdata050 6.xls"

New URL:
"http://company/site/area/Production%20Data/PRODdata2005-2006.xls"

Thanks in Advance,
Raul



Reply With QuoteReply With Quote