Validation Key

[SHAHZAD79]

Hi,
I am preparing salries from Oasis system which generates Excel 2003 salary templete with validation Key
Since we move to Excel 2007 , I am not able to find that key ,
Can someone helpo me to VaLIDATE attach file in 2007?

Thanks in advance

[abousetta]

Hello and welcome to the forum. There is a password-protected vba project on this file. Please either provide the password or another workbook with the password-protection removed. In accordance with forum rules, we are not allowed to help members circumvent security measures. If that is the purpose of this thread, then one of the moderators will lock and prevent any further posts.

[SHAHZAD79]

Not at all...
as I mentioned its a Third party software which creates such file in 2003 version.
When we present to bank it needs to be validated ( Validation Key appreas just above on formula bar).
I just need to know how it works in 2007 version.
Thanks for your prompt reply.

[abousetta]

Hi,

The validation process is done using a vba macro (an Add-In). We can't see what it's doing without seeing the code. In Excel 2010, it shows two optoions "Validate Salary Upload Data" and "Export Salary Upload File". Both seem to work but I don't know what the results should be. The first button gives me a messsage that says "Data Validated successfully" while the second creates a csv file. I'm not sure if this means it works in 2010 and not 2007, but there is no way to see the inner workings of the macro without providing a password or circumventing the security measures. I would advise you to contact the company that produces the software and ask about this problem.

Good luck.

abousetta