Can data be entered from the keyboard in an excel macro while it is being executed? I want to write (record) a macro and while it is running, enter the location for saving the file and then use the same macro to save the same file in a different location as entered from the keyboard.
