Command Buttons...

[tlynn]

Is it possible to have a command button open a specific document, say a word.doc or a excell document and if so, how would I go about doing it? I have tried various experiments via the command button wizard to no avail, so any advice on this would be appreciated. Also, I should say that the forms I am trying to link cannot be imported, rather I would like them to stay in their respective forms (i.e. word.doc or excell).

Thanks in advance-
~T

 

[MyBoo]

Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set Sheet = xlApp.Workbooks.Open("C:\YourExcelFile.xls").Sheets(1)

Search Help for CreateObject