You can see it's a date  format issue - your months and days (7 and 2) are
reversed between the two techniques.

You need to either play with your default Regional and Language Options in
Control Panel or set the formats explicitly after the Workbooks.Open call.
Which one is coming out correctly - the Workbooks.Open call or the
double-click?