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]

Re: How to get Access form names into an Excel file?

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.Current Project.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:::mgf0 0 <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/AwUBR6t4QIechKq OuFEgEQJ4WwCdGz BOLT74M/OTYVBya1ZMCY3E6 YUAoPM/
ZWMeWiO6kqRmzGE 6bF9wiHn7
=Vh++
-----END PGP SIGNATURE-----