Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Close a Folder
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
I don't want to close the workbook I'm working in. I want to close the
folder I just opened using the first codeline. "Bob Phillips" wrote: 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 |
#4
|
|||
|
|||
You don't open a folder, you open workbooks or files. You reference folders.
Thus, you cannot close something that is not opened. -- HTH Bob Phillips "aftamath" wrote in message ... I don't want to close the workbook I'm working in. I want to close the folder I just opened using the first codeline. "Bob Phillips" wrote: 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 |
#5
|
|||
|
|||
This code opens a folder in a new window. ComboBox1 is a string selected by
the user to open a folder. I know that it opens a folder because I ran it and it works. The folder opens up right on the screen. Perhaps there's isn't a code to close the non-application specific folder. "Bob Phillips" wrote: You don't open a folder, you open workbooks or files. You reference folders. Thus, you cannot close something that is not opened. -- HTH Bob Phillips "aftamath" wrote in message ... I don't want to close the workbook I'm working in. I want to close the folder I just opened using the first codeline. "Bob Phillips" wrote: 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 |
#6
|
|||
|
|||
What is the name of this 'folder' that it opens, and what exactly do you
mean by 'open'? -- HTH Bob Phillips "aftamath" wrote in message ... This code opens a folder in a new window. ComboBox1 is a string selected by the user to open a folder. I know that it opens a folder because I ran it and it works. The folder opens up right on the screen. Perhaps there's isn't a code to close the non-application specific folder. "Bob Phillips" wrote: You don't open a folder, you open workbooks or files. You reference folders. Thus, you cannot close something that is not opened. -- HTH Bob Phillips "aftamath" wrote in message ... I don't want to close the workbook I'm working in. I want to close the folder I just opened using the first codeline. "Bob Phillips" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |