I need to retrieve the value of right footer of many excel files. The reason is to get the value and then,modify substring, and write back into it.
For example, I know how to assign right footer value.
ActiveSheet.PageSetup.RightFooter = "TEST123"
But, I can't figure out how to get the...