[RESOLVED] Get Property List

[Resource Dragon]

I've seen lists (usually on a spreadsheet) of a form with its name and properties and the names and properties of all the objects in that form. I assume there is an easier way than copy and paste to get such a list! What is it?

Thanks

[si_the_geek]

I've got no idea how to detect a list of properties, but the names of objects should be fairly easy:

Dim varControl as Variant
  For Each varControl in Me.Controls
     MsgBox varControl.Name
  Next varControl

If it doesn't work, try changing Me to the name of the form.

[Resource Dragon]

That wasn't quite what I had in mind although it could also be useful. See attached file (I didn't create it) for an example of the sort of thing I want. (A quick way of converting the data back to a form would also be handy.)

[si_the_geek]

I'm afraid I have no idea what you want... that doesn't seem to have anything to do with the question you asked.

[westconn1]

i looked at the form, there is nothing in that in relation to your original question,

if you want to put all the details of the forms controls etc

Begin VB.Form frmInvoice 
   BackColor       =   &H00808000&
   Caption         =   "Form1"
   ClientHeight    =   9150
   ClientLeft      =   165
   ClientTop       =   855
   ClientWidth     =   9645
   LinkTopic       =   "Form1"
   ScaleHeight     =   9150
   ScaleWidth      =   9645
   StartUpPosition =   3  'Windows Default
   Begin VB.CommandButton cmdClear 
      Cancel          =   -1  'True
      Caption         =   "CLEAR"
      Height          =   495
      Left            =   7200
      TabIndex        =   9
      Top             =   6360
      Width           =   2055
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "EXIT"
      Default         =   -1  'True
      Height          =   495
      Left            =   7200
      TabIndex        =   10
      Top             =   7200
      Width           =   2055
   End

into a spreadsheet, just open the .frm for input as if it was a .txt and fill a range

[Resource Dragon]

Ah, I fiddled around a bit more and discovered that the answer to my problem was File > Export File. Sometimes the solution to a problem is asking the right question.