Export list of all reports to excel 1

[NeilT123]

Is there a way to export a list of all my report names (and query names if possible) to Excel?

 

[dhookom]

You can export this query:

SELECT msysobjects.Name, IIf([Type]=5,"Query","Report") AS ObjectType
FROM msysobjects
WHERE (((msysobjects.Name) Not Like "~*") AND ((msysobjects.Type) In (-32764,5)));

You should also be able to link this information from within Excel.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[NeilT123]

That was exactly what I wanted, thank you