Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
file folder macro's | Links and Linking in Excel | |||
"Save As" folder -- can I default this to the same folder as origi | Excel Discussion (Misc queries) | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
What is folder OLK7 and where can I find it? | Excel Discussion (Misc queries) | |||
How can I change the appearance of the folder icon | Excel Discussion (Misc queries) |