Hello all - I am a new user to ME, and I seem to be running into a wall with this macro I am trying to write. I have searched with key words "arrow key" and "<arrow down>" and didn't find any posts with a similar problem.
I am trying to write a macro that will open and mine reports on a daily basis. These reports always have the same first 4 characters in the file name day-to-day, but the rest of the file name is often variable (and semi-unpredictable). So what I am doing to try to get to this report is activate the "Open Report" command from the File menu, type in the first four letters of the report which activates the automatic drop-down menu from which I can select the correct report, then press the down arrow to select the first(and only) report in the drop-down menu, and press enter.
This is where I am getting an error. Even though the command seems to work (it's not actually typing out the characters "<ARROW DOWN>"), the arrow key never seems to get pressed, which causes the macro to look for a report named just those first characters, which of course doesn't exist. Can anyone tell me what's going on?
Thanks!
Nick
