I'm looking for a way, using Access 2007 vba, to output a list of all Marco actions to a CSV file.
The field headings would be:
MacroName, Action, Comment, Argument
Sample data might look like this:
AutoUpdate, RunMacro, Create Reports, mcrRunReports
AutoUpdate, SetWarnings, Turn off warnings, 0
AutoUpdate, OpenQuery, Run update query to change run date, qryUpdateRunDate
AutoUpdate, SetWarnings, Turn on warnings, -1
mcrRunReports, SetWarnings, Turn off warnings, 0
mcrRunReports, RunCode, Run code to print user reports, DistributeReports ("qryReportList")
Any help would greatly be appreciated.