Hi,

I'm trying to find out if it's possible to link to a specific excelspreadsheet which isn't currently open. The spreadsheet could beshared between users? I have found and tried the GetObject andCreateObject. These are fine if you want to start a new spreadsheetor access the currently active spreadsheet in excel. But I can'tget access to a specific spreadsheet say C:\SW.xls whether it isopen or not.
Set xl = CreateObject("Excel.Application")
Set xl = GetObject(, "Excel.Application")

The excel API help file showes the GetObject Function syntax asGetObject([pathname],[,class]). I was hoping the solution would beto include the pathname of the excel file before the comma howeverthis doesn't work.
Dim xl As Excel.Application
Set xl = GetObject("C:\SW.xls", "Excel.Application") or
file = "C:\SW.xls"
Set xl = GetObject(file, "Excel.Application")

My goal is to include part numbers in the spreadsheet which can beaccessed by multiple SW users. The macro will automate the bookingout of part numbers from the spreadsheet and add of custom propertyinformation such as part name to the spreadsheet.

Maybe there is a better way of doing this or a database would bemore suitable? I have no database experience which is why I amtrying excel.

Any assistance would be most appreciated.

Cheers.SolidworksApi macros