Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Inserting Comment to Cell in Excel
#1
Hi All,
Just starting to get into the Excel functions. I can do the basics (set cell, get cell, etc) but I would like to set a comment onto a specific cell. I am looking into the VB script in how to do this but not sure how to translate that into QMscript.

I am looking at this example and still confused:
Macro Macro
Code:
Copy      Help
;select range of cells
ExcelSheet es2.Init
es2.ws.Range("A1:B2").Select
;save all files and close Excel
Excel.Application ea=es2.ws.Application
Excel.Workbook wb; foreach(wb ea.Workbooks) wb.Save
ea.Quit

I see a ws.Comments option but not sure how to syntax it for a specific string insert and cell address.

Thanks for any help!

Stuart


Messages In This Thread

Forum Jump:


Users browsing this thread: 6 Guest(s)