DominicB your code works well but I was hoping to open a specific word document. Is there any way of doing this as I'm hoping to copy data from Excel and paste it in a word document that is already saved. It is the same with the Access problem.
As an aside, this piece of code will open a Word document (in this case c:\wordy.doc) using the users standard registered software for .doc files. Therefore if a user doesn't use microsoft but one of the alternative office suites using the .doc extension, it will open the relevant piece of software.
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
ShellExecute 0, vbNullString, "wordy.doc", vbNullString, "c:\", 1