*getGlobalDataxlsPath()shall return the complete path of "GlobalData.xls" file
This is a small part to understand getGlobalDataxlsPath()
Now the logic behind having an entry point for your Automation framework is whenever you execute any script, your framework structure should be available in Execution QTP environment. Since "GlobalData.xls" itself contain the structure, how you gonna access this excel sheet seamlessly.
One Idea, let's leverage QTP's Enviroment("TestDir") variable.
So your function called getGlobalDataxlsPath() Should return a path like for example
"C:\\whereveryouhaveplaced\GlobalData.xls"
Colored path is what we need to extract.
Look at below code
I hope you got dat!!!
Notice the dependency, your Framework Base folder should contain the word "Framework".
This is a small part to understand getGlobalDataxlsPath()
Now the logic behind having an entry point for your Automation framework is whenever you execute any script, your framework structure should be available in Execution QTP environment. Since "GlobalData.xls" itself contain the structure, how you gonna access this excel sheet seamlessly.
One Idea, let's leverage QTP's Enviroment("TestDir") variable.
So your function called getGlobalDataxlsPath() Should return a path like for example
"C:\\whereveryouhaveplaced\GlobalData.xls"
Colored path is what we need to extract.
Look at below code
Function getGlobalDataxlsPath()
getGlobalDataxlsPath = Mid(Environment("TestDir"), 1, instr(1,Environment("TestDir"), "Framework")+10)
End Function
I hope you got dat!!!
Notice the dependency, your Framework Base folder should contain the word "Framework".
-Pankaj Dhapola
Let's Think on it
