How to set excel cell font bold

[yadhukrishna36]

Hi I want to set the font of a specific cell range in the excel sheet to BOLD
I tried

Code: Select all

 
  VBStart
      Sub setExcelCellBold(vbFilePath)
        Set objExcel=CreateObject("Excel.Application")
    	  objExcel.Visible = false
        Set objWorkbook = objExcel.Workbooks.Open(vbFilePath)
        Set objRange = objExcel.Range("CB3","CD3")
        objRange.Font.Bold = TRUE
        objWorkbook.Save
        objWorkbook.Close
        objExcel.Quit
      End Sub
    VBEND
    
    Let>filePath=C:\Users\Radesh\Desktop\fontBoldTest.xlsx
    VBRun>setExcelCellBold,%filePath%

It's working but I would like to use macro scheduler functions like

XLSetRangeFormat>xlbook,%sheet%,A1,Font.Bold=True
Thanks in advance

[Dorian (MJT support)]

As of Macro Scheduler Version 15.0.02 19/02/2020. Not available in Lite.

For this you need XLRunCode. It can be used to run a single line of code or an entire block of code (samples are in the linked help file).

Code: Select all

XLopen>d:\output.xlsx,1,xlH
XLRunCode>xlH,ActiveSheet.Range("CB3:CD3").Font.Bold = True

[Dorian (MJT support)]

As an afterthought to help you in future... this article shows how to generate vba for use with XLRunCode.