Jump to content

Recommended Posts

Posted

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

Posted

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)
Posted

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.

Posted

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)

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...