I appreciate your help, Mike, but I am afraid the problem remains. I
still get the two prompt screens which I have to satisfy with manual
entries (although I didn't get any of the bizzare run errors generated
by some of the permutations I tried)!

I ran accross a "SendKeys Method" in Excel's VBA Help which places
keystrokes in a key buffer (haven't seen that used in quite a while).
It then goes on to say

In some cases you must call this method before
you call the method that will use the keystrokes.
For example, to send a password to a dialog
box, you must call the SendKeys method before
you display the dialog box.

Intuitively, I am inclined to think "the method" might do the trick,
but at my level of understanding this two sentence explanation has
left me scratching my head.

Thanks,
Eric