mafioso Posted July 24, 2008 Share Posted July 24, 2008 I am trying for more than hour to create borders from B5 to C10 (B10-C10). I've tried so MANY different ways, but really, really none of them work. It only creates border on B5. I am using Excel 2003 and I removed tintandshade so it works with it. PLEASE HELP ! I really don't know, for example, why this won't work : _ExcelCreateBorders ($oExcel, $xlThin, "B5", "B", "10", "C") In description, it says : $oExcel - An Excel object opened by a preceding call to _ExcelBookOpen() or _ExcelBookNew() ; $sBorderStyle - The type of border to use, $xlThick, $xlThin, $xlDouble ; $sRangeOrRowStart - Either an A1 range, or an integer row number to start from if using R1C1 ; $iColStart - The starting column for the number format(left) (default=1) ; $iRowEnd - The ending row for the number format (bottom) (default=1) ; $iColEnd - The ending column for the number format (right) (default=1) So, $sRangeOrRowStart = B5, $iColStart = B, $iRowEnd = 10, $iColEnd = C In translation, create borders in columns B and C, from row 5 to 10. Please heeeeeeeeelp .... Link to comment Share on other sites More sharing options...
PsaltyDS Posted July 24, 2008 Share Posted July 24, 2008 I am trying for more than hour to create borders from B5 to C10 (B10-C10). I've tried so MANY different ways, but really, really none of them work. It only creates border on B5. I am using Excel 2003 and I removed tintandshade so it works with it. PLEASE HELP ! I really don't know, for example, why this won't work : _ExcelCreateBorders ($oExcel, $xlThin, "B5", "B", "10", "C") In description, it says : $oExcel - An Excel object opened by a preceding call to _ExcelBookOpen() or _ExcelBookNew() ; $sBorderStyle - The type of border to use, $xlThick, $xlThin, $xlDouble ; $sRangeOrRowStart - Either an A1 range, or an integer row number to start from if using R1C1 ; $iColStart - The starting column for the number format(left) (default=1) ; $iRowEnd - The ending row for the number format (bottom) (default=1) ; $iColEnd - The ending column for the number format (right) (default=1) So, $sRangeOrRowStart = B5, $iColStart = B, $iRowEnd = 10, $iColEnd = C In translation, create borders in columns B and C, from row 5 to 10. Please heeeeeeeeelp .... Use either a range or row/col numbers, but don't mix them: #include <ExcelCOM_UDF.au3> $oExcel = _ExcelBookNew() _ExcelCreateBorders($oExcel, $xlThin, "B5:C10") _ExcelCreateBorders($oExcel, $xlThick, 12, 2, 14, 3) I also had to comment out all the instances of .TintAndShade = 0 for it to run... 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