How to get Access form names into an Excel file?

[tomg]

How can I get all of my MS Access form names into an Excel file?

thanks,

[MGFoster]

tomg wrote:

How can I get all of my MS Access form names into an Excel file?

thanks,

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use CurrentProject.Forms. E.g. in the debug window (Ctrl-G):

for each frm in currentproject.allforms : debug.Print frm.name : next

If you want this to run from Excel you'll have to open Access as an
Automated object. See GetObject and CreateObject in the Excel VBA help
file. Then add the Access object to the above references
(accObj.CurrentProject.Forms) and use the above code to insert the form
names in Excel cells.

The easiest way is to run the above code in Access debug window and cut
& paste the results into Excel.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR6t4QIechKqOuFEgEQJ4WwCdGzBOLT74M/OTYVBya1ZMCY3E6YUAoPM/
ZWMeWiO6kqRmzGE6bF9wiHn7
=Vh++
-----END PGP SIGNATURE-----