SAMSashi Posted December 28, 2010 Share Posted December 28, 2010 Hi Guys,I want to write the details of pages i navigate into an Excel file through my AutoIT v3 script. Problem I am facing : I am able to navigate Internet pages from one page to other through script.But if i start to write to Excel file using-#include <Excel.au3>$sFilePath1 = @ScriptDir & "\TimeDetails.xls" $oExcel = _ExcelBookOpen($sFilePath1)$iBegin_Login_Page = TimerInit();; doing some work $nTimetaken = TimerDiff($iBegin_Login_Page)_ExcelWriteCell($oExcel,"$iBegin_Login_Page",2,3)Want to go back to resume my page navigation work and gathering the information to write in Excel file;I am not able to do that. Can you just help in resolving this.Regards,SAM Link to comment Share on other sites More sharing options...
saywell Posted December 28, 2010 Share Posted December 28, 2010 Hi Guys,I want to write the details of pages i navigate into an Excel file through my AutoIT v3 script. Problem I am facing : I am able to navigate Internet pages from one page to other through script.But if i start to write to Excel file using-#include <Excel.au3>$sFilePath1 = @ScriptDir & "\TimeDetails.xls" $oExcel = _ExcelBookOpen($sFilePath1)$iBegin_Login_Page = TimerInit();; doing some work $nTimetaken = TimerDiff($iBegin_Login_Page)_ExcelWriteCell($oExcel,"$iBegin_Login_Page",2,3)Want to go back to resume my page navigation work and gathering the information to write in Excel file;I am not able to do that. Can you just help in resolving this.Regards,SAMIf you make the excel bit into a function, you could call it between each of your actions elsewhere in the script. How are you navigating between pages?William Link to comment Share on other sites More sharing options...
SAMSashi Posted December 30, 2010 Author Share Posted December 30, 2010 I meant for page navigation as the IE pages. With the help of 'Autoit Windows Info', i get the Title and then Send(TAB+ENTER) to go to next page thats it. Thanks for the information. SAM Link to comment Share on other sites More sharing options...
SAMSashi Posted December 31, 2010 Author Share Posted December 31, 2010 I meant for page navigation as the IE pages. With the help of 'Autoit Windows Info', i get the Title and then Send(TAB+ENTER) to go to next page thats it. Thanks for the information.SAMAnybody can help me if i want to check whether the Excel sheet is open or not how can i check that.Thanks,SAM Link to comment Share on other sites More sharing options...
bolopaneer Posted December 30, 2011 Share Posted December 30, 2011 see this Determine If A Process is Runningin this linkhttp://dailycupoftech.com/useful-autoit-scriptlets/ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now