Excel References and Object libraries

Hi,
I have an issue where I set up a shared spreadsheet which is used by Excel 2003 and Excel 2010 users.

If someone who uses 2010 saves the spreadsheet it no longer becomes usable for 2003 users due to it now using 12.0 instead of 11.0 references (There is a reference to Word in there due to a macro which creates some letters for the user).

My question is, is there a way of assigning the relevant references to the user when they open the spreadsheet depending on which Excel they are running?

Many thanks
Paul

Thanks for the quick reply Norie,

I'm not much of an expert on this type of code but the way it is coded at the moment is as follows (I think I have the relevant bits);

Private Sub cmdOK_Click()
On Error GoTo Errorhandler

txtAmount = FormatCurrency(txtAmount, 2, IncludeLeadingDigit:=vbTrue)

'checks all details completed
AllCompleted = False
Call CheckCompleted
If AllCompleted = True Then Exit Sub

'create new word session if none running
'Dim appWd As Word.Application
Set appWd = GetObject(, "Word.Application")
If appWd <> "Microsoft Word" Then
Set appWd = New Word.Application
End If

'Set appWd = CreateObject("Word.Application")
appWd.Visible = True

'Filepath
GPRdoc = Range("GPRPath")

'disable word macros
appWd.WordBasic.DisableAutoMacros 1

'create GPR
Set wrddoc = appWd.Documents.Add(GPRdoc)

'show GPR
appWd.Activate

'disable word macros
appWd.WordBasic.DisableAutoMacros 0

'insert details
With wrddoc

'Inserts Our ref
If .Bookmarks.Exists("Our_Ref") = True Then
.Bookmarks("Our_Ref").Range.InsertAfter txtOurRef
End If


Would this be classed as late-binding/declaring the object? If not do you please have any tips of where to change this code?

Many Thanks

BTW really sorry I can't add code tags - the forum doesn't work for me at work (IE7!) so am try to struggle along using my phone at the moment.