I have an Excel file and which contain a column "Ver_num" in a sheet called ver_mgmt. After every changes to the source file, the Ver_num will increase by one. I want to load file if the version number matches with the current version number else it should give me a pop up saying the version number is updated.
suppose the current version number is 5 and i have loaded the file. now my QVW will have the version number 5. After making changes to the file , i will update the version number in excel file. Now the script should check for the latest version number and load the data into qvw.
I thought of creating a variable to store the max of the version number. But how i can look for the latest version number?
