Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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". |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
can I bypass "Windows has encountered a problem" | Excel Discussion (Misc queries) | |||
How to "bypass" run-time error '91'???? | Excel Programming | |||
Bypass "DISable Macros" | Excel Programming |