hi ,
I am using this program to open an excel sheet then running a macro ( getting successful till here) but now i want to activate one excel sheet name "Market Data" and copy paste some data here but not hapeening.
Please help
$oExcel = _ExcelBookOpen ("C:MarketTmacro.xlsm")
Sleep(200)
$oExcel.Run("Macro1")
Sleep(200)
Send("^+{DOWN}")
Sleep(200)
Send("+{RIGHT 5}")
Sleep(200)
Send("^c")
Sleep(200)
_ExcelSheetActivate($oTmacro, $vMarket Data)