SorryButImaNewbie Posted October 7, 2016 Posted October 7, 2016 (edited) Hello First, I thank you for all the help I received here with Excel UDFs and COM objects in the last few days/week. I would like to "pimp" my output excel a bit, and for that I would like to write some results Bold. How do I do that? I tried a few things but most return errors, or doesn't do a thing seemingly. My code right now, this does run, but doesn't make the inserted results bold. (by inserted I mean what I write with _Excel_RangeWrite) _Excel_RangeWrite($ExcelObject, $ExcelObject.Activesheet, "=" & $OSSZEGoszlop & $CellaOlvasoSzamlalo & "*" & String($ArfolyamArray[$DateArrayTimeIndex]) & "", String($sHUFBeszurOszlop) & $CellaOlvasoSzamlalo) $ExcelObject.Activesheet.Range(String($sHUFBeszurOszlop) & $CellaOlvasoSzamlalo).Bold = True Thank you for the help! Edit: I leave this here, added the bold tag, maybe someone find it usefull Edited October 7, 2016 by SorryButImaNewbie
SorryButImaNewbie Posted October 7, 2016 Author Posted October 7, 2016 Okey, thanks to Murphy again... Around 10 minutes after I decided to humiliate myself again, with posting pretty easy questions, I found the solution. https://www.autoitscript.com/wiki/Excel_UDF#Bold_etc. $ExcelObject.Activesheet.Range(String($sHUFBeszurOszlop) & $CellaOlvasoSzamlalo).Font.Bold = True Have to specify that I talk about Font first (.Font) to the COM, in my leman terms.
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