Multi-tab Excel output from NAV using Excel Buffer?

boywonder

This is one I have solved before but even though I have the objects I can't get it to work this time around....

All I did last time was add a function into Table 370 Excel Buffer...

AddNewSheet()
XlWrkSht := XlWrkBk.Worksheets.Add;

Then call the function from inside my report (ExcelBuffer.AddNewSheet;)

But I am getting the following:

This message is for C/AL programmers:

This Automation variable has not been instantiated.
You can instantiate it by either creating or assigning it.

btw - I have already written entries to the ExcelBuffer table at this point.

Any ideas? :-k

boywonder

can this be deleted please as I solved it using ExcelBuffer.CreateBook

\:D/

kine

That you yourself answered the question doesn't mean that it can be deleted. May be it will help someone else when searching for answers. Mark the first post as "solved" and it will be ok... ;-)