topic Re: Folders in VBA Forum

Folders

Anonymous — Tue, 10 Aug 2004 14:26:45 GMT

Hi Group, VB has an intrinsic control called DirListBox. Is there a similar control available to programmers using VBA? Thanks, Ken Hutson San Antonio, TX

Re: Folders

Anonymous — Tue, 10 Aug 2004 15:39:09 GMT

No, most people use the Windows API. Joe -- "Ken Hutson" wrote in message news:4118daa2_2@newsprd01... > Hi Group, > > VB has an intrinsic control called DirListBox. Is there a similar control > available to programmers using VBA? > > Thanks, > Ken Hutson > San Antonio, TX > >

Re: Folders

Anonymous — Tue, 10 Aug 2004 16:31:42 GMT

Ok, thanks Joe. Ken "Joe Sutphin" wrote in message news:4118ec35_2@newsprd01... > No, most people use the Windows API. > > Joe > -- > > "Ken Hutson" wrote in message > news:4118daa2_2@newsprd01... > > Hi Group, > > > > VB has an intrinsic control called DirListBox. Is there a similar control > > available to programmers using VBA? > > > > Thanks, > > Ken Hutson > > San Antonio, TX > > > > > >

Re: Folders

Anonymous — Tue, 10 Aug 2004 23:46:24 GMT

Although you can not use VB intrinsic controls in VBA you can create your own controls in VB using the intrinsic controls.
This is from a document titled 'Building ActiveX Controls' which is part of the VB5 Control Creation Edition documentation.

-----Begin Excerpt-----
Controls You Can Use As Constituent Controls
You can place any of the controls supplied with Visual Basic on a UserControl, with the exception of the OLE container control.
Any ActiveX control you’ve purchased, or any control written to the older OLE specification, can be placed on a UserControl.
As long as you’re authoring a control for your own use, that’s all you need to know. However, if you’re going to distribute your control to others, even if you’re giving it away, you need to consider distribution and licensing issues.
Note Toolbox objects other than controls, such as insertable objects — for example, Microsoft Excel Charts — cannot be placed on UserControl objects.

The Easy Part — UserControl and Intrinsics
The UserControl object and the Visual Basic intrinsic controls are created by the Visual Basic run-time DLL. Anyone who installs your .ocx file will automatically get a copy of the run-time DLL and support files, so if you author your controls using just the UserControl and intrinsic controls, you have no further licensing or distribution issues to worry about.
The intrinsic controls include: PictureBox, Label, TextBox, Frame, CommandButton, CheckBox, OptionButton, ComboBox, ListBox, HScrollBar, VScrollBar, Timer, DriveListBox, DirListBox, FileListBox, Shape, Line, Image, and Data.
ActiveX controls included with the Professional Edition of Visual Basic are subject to licensing rules, as explained below.
-----End Excerpt-----

Regards - Nathan