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