maurocav Posted March 26, 2007 Posted March 26, 2007 I ave already running a instance of Excel (test.xls) How can it paste into $file ? like this $File = _ExcelBookOpen($FilePath) ; Open the workbook Local $cell = _ExcelReadCell($FilePath,"e5") .... Tank
maurocav Posted March 26, 2007 Author Posted March 26, 2007 Please help me I ave this,but result 0 Tank #include <ExcelCOM_UDF.au3> Dim $FilePat WinActivate("Microsoft Excel", "") $FilePath = ControlGetHandle("Microsoft Excel", "", "test.xls") $File = _ExcelBookOpen($FilePath); Open the workbook Local $cell = _ExcelReadCell($File,"A5") MsgBox(0, "", $cell)
flyingboz Posted March 26, 2007 Posted March 26, 2007 You haven't defined an object to work with yet. Refer to usage examples in your UDF of choice. Reading the help file before you post... Not only will it make you look smarter, it will make you smarter.
maurocav Posted March 26, 2007 Author Posted March 26, 2007 I ave this tried but not work Other examples ave not found please help me #include <ExcelCOM_UDF.au3> Dim $FilePat WinActivate("Microsoft Excel", "") $FilePath = ObjGet("","Microsoft Excel") $FilePat = ControlGetHandle($FilePath, "", "") $File = _ExcelBookOpen($FilePat); Open the workbook Local $cell = _ExcelReadCell($File,"A5") MsgBox(0, "", $cell)
Gollum Posted March 27, 2007 Posted March 27, 2007 #include <ExcelCOM_UDF.au3> Dim $oExcelDoc, $cell WinActivate("Microsoft Excel", "") $oExcelDoc = ObjGet("","Excel.Application") $cell = _ExcelReadCell($oExcelDoc,"A5") MsgBox(0, "", $cell)
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