Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Raj wrote:
On Jul 24, 3:13 pm, CoRrRan wrote: Raj wrote: Hi all, I would like to know if using a macro can we hide a folder, if yes can i know how can i do it....... Yes you can: **************** Sub ChangeFolderAttribs() Dim FSO As Scripting.FileSystemObject Set FSO = New Scripting.FileSystemObject FSO.GetFolder("C:\Temp\").Attributes = Hidden Set FSO = Nothing End Sub **************** Make sure you have a reference to "Microsoft Scripting Runtime" (VBE -- Tools -- References -- select "Microsoft Scripting Runtime" and close with "OK".) CoRrRan Thx.......... how to unhide the folder........... Change: FSO.GetFolder("C:\Temp\").Attributes = Hidden To: FSO.GetFolder("C:\Temp\").Attributes = Normal CoRrRan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to look for the Folder Path using macro???? | Excel Programming | |||
Run macro from directory folder...? | Excel Programming | |||
Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
Creating a folder using macro... | Excel Programming | |||
Macro Folder | Excel Programming |