Excel automation: export message to office assistant

Marc_Vermeulen
Marc_Vermeulen Member Posts: 3
edited 2006-01-09 in Navision Attain
Hello,

I am very happy user of the Excel automation tool in Navision (we are using 3.6). I wonder whether it is possible to send an instruction to the office assistant and let him display this message just after confirming some report with Excel automation / export.

Or, when this is not possible, can I place a in Excel so-called "comment" instead (the optional little red triangle in the right top corner of a cell)?

Thank you in advance!


Marc

Comments

  • Timo_Lässer
    Timo_Lässer Member Posts: 481
    Look here: [Download] Office Assistant in Navision
    Timo Lässer
    Microsoft Dynamics NAV Developer since 1997
    MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
  • Marc_Vermeulen
    Marc_Vermeulen Member Posts: 3
    Timo Lässer wrote:
    Look here: [Download] Office Assistant in Navision

    Hello Timo,

    Thanks, but I have already checked this topic and could not find the right solution there.

    This is not what I need, the topic describes how to get the office assistant IN Navision. I need something to send a message TO Excel: start an Excel automation report in Navision, Navision exports some data AND a comment to Excel. Excel will open and shows the exported data and the office assistant with the comment that I wrote in Navision.

    It should be something like this:

    In the Navision report:

    1) Make a variable with data type "automation" and ??? as subtype.
    2) Write the code that exports some comment to Excel and let the office assistant display in Excel the comment. I have used several codes that look like this: ExcelAssistant.Command('blabla');

    But it does not work. I hope my question is more clear now.

    Greetings, Marc
  • fb
    fb Member Posts: 246
    Have you tried something like this? 
    xlSheet.Range('A1').NoteText('Note text here');
    or like this? 
    xlSheet.Range('A1').AddComment('Comment text here');

Categories