View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_43_] Jeff[_43_] is offline
external usenet poster
 
Posts: 6
Default How to bypass "Enter Parameter Value" via macros

I have a simple macro to Generate a Report that I will use for several
databases; however, I have certain datafields that are present in some
databases and not others -- which is okay. My issue is when executing
the report macro on a database that does not have these datafields, I
get a separate popup window ("Enter Parameter Value"). If I don't enter
anything and manually click "Okay", the macro will complete the
remaining steps and generate the report.

Question - What can I do to have the Macro click "Okay" and complete
the remaining steps. My goal is to bypass the manual click of "Okay".