How to reference a SWS subfolder in Excel VBA
 

An Excel spreadsheet contains VBA code that looks up information from other
spreadsheets located in a subfolder. Everything works properly when the
spreadsheet is opened from a Windows desktop. When the spreadsheet and the
subfolder containing the 'lookup' spreadsheets are placed on a SWS web site,
the VBA code encounters an error saying that the subfolder does not exist.
How can we alter the VBA code to properly reference a subfolder on a
sharepoint web site?

Thanks,

Keith