I have read through a variety of folks seeming to want to open / write excel
files from/to a sharepoint server. I have tried a variety of permutations to
open an excel file (from an excel based VBA subroutine), but keep getting a
runtime 424 error (object required) on the workbook.open line. Here are the
two approaches I have tried:

Workbook.Open "\\mysharepoint.mycompany.com\team\myspfolder\ sub
folder\Myfile Data.xls"

(note there is a blank between "sub" and "folder" above)

or

Workbook.Open
"\\mysharepoint.mycompany.com\team\myspfolder\sub% 20folder\Myfile%20Data.xls"

and neither works. There are spaces in the some of the folder names, as
well as the name of the excel file I am trying to open.

Any idea what I am doing wrong?

Many thanks!
PatK