Excel automation: export message to office assistant

Marc_Vermeulen

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

Timo_Lässer

Look here: [Download] Office Assistant in Navision

Marc_Vermeulen

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

Have you tried something like this?

xlSheet.Range('A1').NoteText('Note text here');

or like this?

xlSheet.Range('A1').AddComment('Comment text here');