Provide input value to another macro

[cknutson]

Hello,

I am creating a macro which must open another excel workbook and run a second macro in that workbook. I have no issues getting the other workbook to open or to start the macro.
ASFMarketValues_Date
However, at the start of the macro is an InputBox popup which requires a response. I am unfamiliar with how to populate the needed text and press "OK". Preferably the box would be filled with "CompletedReport_mm.dd.yyyy" where mm.dd.yyyy = today's date.

I've attempted to use SendKeys, but this does not seem to work. I also cannot access the code for the second macro because it is password protected.

Application.Run "'XML Creator for Revport.xls'!create_xml"

 

[Gary McMaster]

I've also seen a freeware version of the program below. I believe it will be able to click "OK" or whatever but I'm not sure if it can do anything for you in the way of entering data in an input box. I've never actually used this program but have often seen it recommended for this type of scenario.

http://push-the-freakin-button.en.softonic.com/?ab=5

Gary