erezlevi Posted December 31, 2007 Share Posted December 31, 2007 hi, I am trying to understand the meaning of the objcreate command and how to use it in order to pass information between windows applications. I am trying to open an Excel file: and I want to fill it in with some string values. is there a way to pass parameters / strings to the Excel worksheet using the OBJ commands? Thanks, $oExcel=ObjCreate ("Excel.Application") if @error then Msgbox (0,"ExcelTest","Error Getting an active Excel Object. Error code: " & hex(@error,8)) exit endif $oExcel.Visible = 1 ; Let the guy show himself $oExcel.workbooks.add ; Add a new workbook $oExcel.worksheets.add ; Add a new worksheet exit Link to comment Share on other sites More sharing options...
PsaltyDS Posted December 31, 2007 Share Posted December 31, 2007 hi,I am trying to understand the meaning of the objcreate command and how to use it in order to pass information between windows applications. I am trying to open an Excel file: and I want to fill it in with some string values. is there a way to pass parameters / strings to the Excel worksheet using the OBJ commands? Thanks, $oExcel=ObjCreate ("Excel.Application")if @error then Msgbox (0,"ExcelTest","Error Getting an active Excel Object. Error code: " & hex(@error,8)) exitendif$oExcel.Visible = 1 ; Let the guy show himself$oExcel.workbooks.add ; Add a new workbook$oExcel.worksheets.add ; Add a new worksheetexitDownload Locodarwin's ExcelCOM_UDF.au3 and poke around in there for many good examples, or just #include that file and use his functions. Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law 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