How do I open a non excel file from within VBA?

[DipDip]

Hi all,
So I'm using a userform to open a particular file via a vlookup from 2 combobox inputs. However, it won't work with non excel files. Can anyone help me with this?

I use the following code:

Private Sub OkButton_Click()
Dim loc As Variant
loc = Application.VLookup(Me.ComboBox2.Value, Sheets("Locations").Range("B2:c2525"), 2, True)
Workbooks.Open (loc)

However, some of the files are Word documents & Publisher files and obviously workbooks.open won't let you do this. Is there a way that it will open the file from the cell reference irrespective of what type of file it is?

Thanks in advance for any help anyone can give me.

 

[Kenneth Hobson]

Shell "cmd /c " & """" & loc & """", vbNormalFocus

 

[DipDip]

Cheers for that. However I plan to add a print function to this. The idea being that in a text box they type how many copies they'd like printed of the file. Would this still work with this code? Or does it need to be done another way?