Activeworkbook.Close

--
HTH

Bob Phillips

"aftamath" wrote in message
...
Here is the VBA code used to open a folder from a command button;

Private Sub Go1_Click()

ActiveWorkbook.FollowHyperlink Address:="D:\Documents and
Settings\Desktop\Products\" & ComboBox1, _
NewWindow:=True

ActiveWorkbook.Address("D:\Documents and Settings\Michael
Groll\Desktop\Products\Honeywell").Close

End Sub

The second item in the code isn't correct at all for closing the folder.
Is
it possible with VBA and, if so, how do I write the code. Thanks