UserForm - vba errors only when opening Excel file from Spaces site

I have a working Excel file that contains vba to display a userform. It works fine run locally or from network.

When I put the document on a browser-based, Spaces site we use for sharing documents,I start to get code errors and they al;l seem to relate to the work/book/worksheet not being found (e.g. subscript out of range).

I have tried using Application.Workbook("workbook.xls").Worksheets("worksheet1") to give a full path. I have also tried using ThisWorkbook. I still have errors.

The VBA project consists of 1 user form and 1 module. Currently, references to the worksheet in the userform seem ok and don't produce errors. References in the module do produce errors.

Has anyone seen anything similar. I was really hoping to find some way of getting this working on Spaces. It's so annoying!

I didn't actually give the full path because i wasn't sure what to use - as it is browser based, I don't know if I would use url (e.g. http://spaces.com/excel.xls) or what. I can give it a try.

I need to look at what format is for specifying path - e.g. Workbooks("http://spaces.com/excel.xls).Worksheets etc