mtbfrigo Posted May 7, 2008 Posted May 7, 2008 hi, can i set the page setup Orientation after excel creation and before write text in cells? CODE$oExcel = _ExcelBookNew(0) _ExcelColWidthSet($oExcel,1,15) _ExcelColWidthSet($oExcel,2,15) _ExcelColWidthSet($oExcel,3,15) _ExcelColWidthSet($oExcel,4,15) _ExcelColWidthSet($oExcel,5,20) _ExcelColWidthSet($oExcel,6,20) _ExcelColWidthSet($oExcel,7,20) _ExcelFontSetProperties($oExcel, 1, 1, 1, 7, TRUE, False, False) ; set landscape _ExcelWriteCell($oExcel,"DATE",1,1) Thanks HiermibraWY 1
Triblade Posted May 7, 2008 Posted May 7, 2008 Maybe this helps?http://www.puremis.net/excel/cgi-bin/yabb/...?num=1126573801 My active project(s): A-maze-ing generator (generates a maze) My archived project(s): Pong3 (Multi-pinger)
mtbfrigo Posted May 8, 2008 Author Posted May 8, 2008 Maybe this helps?http://www.puremis.net/excel/cgi-bin/yabb/...?num=1126573801Well, I started to use autoit just 2 weeks ago and I don't know VBA. I found the command xlLandscape, but I'm not able to convert from vba to autoit.Please, help me, thanks
mtbfrigo Posted May 8, 2008 Author Posted May 8, 2008 Well, I started to use autoit just 2 weeks ago and I don't know VBA. I found the command xlLandscape, but I'm not able to convert from vba to autoit.Please, help me, thanksok, i found the problem, i forgot to specify Activesheet!
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