Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive, folder and File controls
Returning to working with VBA in Excel 2007 after a bit of a break. I can't
remember which library I have to reference to enable the Drives, Folders and Files objects on the form toolbox. Can anyone point me in the right direction. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive, folder and File controls
Microsoft Scripting Library if you want FileSystemObject.
-- __________________________________ HTH Bob "Murray Taylor" wrote in message ... Returning to working with VBA in Excel 2007 after a bit of a break. I can't remember which library I have to reference to enable the Drives, Folders and Files objects on the form toolbox. Can anyone point me in the right direction. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive, folder and File controls
Thanks for that, it's actually the library that puts the Drives, folders and
files list box controls onto the form toolbox in VBA. I have the FSO working. "Bob Phillips" wrote: Microsoft Scripting Library if you want FileSystemObject. -- __________________________________ HTH Bob "Murray Taylor" wrote in message ... Returning to working with VBA in Excel 2007 after a bit of a break. I can't remember which library I have to reference to enable the Drives, Folders and Files objects on the form toolbox. Can anyone point me in the right direction. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive, folder and File controls
That would be additional controls from the forms toolbox then.
-- __________________________________ HTH Bob "Murray Taylor" wrote in message ... Thanks for that, it's actually the library that puts the Drives, folders and files list box controls onto the form toolbox in VBA. I have the FSO working. "Bob Phillips" wrote: Microsoft Scripting Library if you want FileSystemObject. -- __________________________________ HTH Bob "Murray Taylor" wrote in message ... Returning to working with VBA in Excel 2007 after a bit of a break. I can't remember which library I have to reference to enable the Drives, Folders and Files objects on the form toolbox. Can anyone point me in the right direction. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drive, folder and File controls
that's what I thought but I can't seem to find the right item!, thanks for
your assistance. "Bob Phillips" wrote: That would be additional controls from the forms toolbox then. -- __________________________________ HTH Bob "Murray Taylor" wrote in message ... Thanks for that, it's actually the library that puts the Drives, folders and files list box controls onto the form toolbox in VBA. I have the FSO working. "Bob Phillips" wrote: Microsoft Scripting Library if you want FileSystemObject. -- __________________________________ HTH Bob "Murray Taylor" wrote in message ... Returning to working with VBA in Excel 2007 after a bit of a break. I can't remember which library I have to reference to enable the Drives, Folders and Files objects on the form toolbox. Can anyone point me in the right direction. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links to Local Drive Instead of Same Folder | Excel Discussion (Misc queries) | |||
Folder Network drive | Excel Discussion (Misc queries) | |||
add a folder to c:\ drive from cell A1 contents... | Excel Discussion (Misc queries) | |||
Prgrammatically save a file to a specific folder on a network drive | Excel Programming | |||
Pasting a range of information from a foler on F Drive to another folder on same drive | Excel Programming |