Hi all

I am seriously hoping someone can help.

I have created a Userform, which accesses a hidden sheet and dependin
on the selection runs a formula from the sheet and opens a relevan
spreadsheet...

But...........

I have now adapted this to open another set of files, but these ar
.doc and therefore won't open.

I have used the below to open Excel files and works fine. I am hopin
someone can help adapt it to a word document.

Thanks guys

David

Private Sub CmdOPEN_Click()
Worksheets("SHEET1").Range("a2").Value = cm1
megafile = Worksheets("SHEET1").Range("A1").Value
Windows("OPEN INFO.xls").Visible = False
Application.ScreenUpdating = True
Workbooks.Open megafile, False, True
Unload Me
End Su

--
Message posted from http://www.ExcelForum.com