****Now how do i check whether a macro is present or not in a report.i will have to produce a output "yes" if macro is there and "no" if it not there in a msgbox. But first of all i dont know to check manually after openeing a report. where can i see which macro is used in a report
A macro in a report can only be invoked in one way. Open the report, click on the report menu and from the dropdown select macro. You will see a dialog box to select a macro that will execute when the report is run. If the dialog box is empty then the report does not contain a macro.
To check the other way round (if a macro contains a report) is more involved. You will need to open each macro and then check the code.
NKT