Jump to content

[SOLVED]_Excel_RangeWrite How to Bold?


Recommended Posts

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 by SorryButImaNewbie
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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
 Share

×
×
  • Create New...