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.

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.

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.

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.

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.