Macros and prompts

[maldocad]

I have 7 independent reports that use the same information from the prompts.

I wrote a Macro to obtain the information and try to run the seven reports without inputing the information over.

How could I transfer the variables from my macro to the prompt manager??

 

[goatnorm]

You would want to create a for loop in your macro and then execute the line:
Set ImpRep = ImpApp.OpenReport (ImpRepPath & ImpDoc & ".imr", Prompt1)
Using this, you would only have to enter the Prompt1 information one time, and can send it to the report as many times as you need to (the number of reports you have). If you have further questions, post them and I'll try to help out.

Chad