This content has been marked as final. Show 2 replies
1 person found this helpful
I don't think there is an option for preserve formulas and comments.
You can use this sts = HypSetGlobalOption(1, True) to set it to EXCEL formatting (however this won't preserve the formula)
Thanks celvin for the reply