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
xlseet.ActiveSheet.UsedRange.Rows.Count
or
xlseet.Cells.Item[10,10]
Any Idea on how to work with xlsm formatted files
Hi Kavitharaj,
I suppose that you can work with your xlsm file via Excel’s COM Object: http://smartbear.com/viewarticle/69443/
Can you?
