Need to work with xlsm file to fetch the data and compare

Hi,   I have an xlsm format of excel. I need to fetch the data from it and compare against different columns in the same file. I am not able to use any regular excel statements on that file. Like...