I'd try to create a stored process from the program, with both those dates supplied from user prompts. Then I'd look how to automatically send the dates to those SAS prompts via VBA.
But that would be a secondary option by a mile. My primary option would be to do it all on the proper platform, and avoid all those Excel interaction shortcomings.
... View more