How to Get rid of Additional 'Excel Sheet'

nikeman77

hi guys,

when i export to excel i want to shows only the sheets that is created, is there any way to eliminate those 'sheet1..sheet3'?

postsaurav

Hi,

I hope this is what you are looking for -

http://saurav-nav.blogspot.in/2013/02/export-to-excel-delete-un-used-sheets.html

Let me know if you have any issues.

nikeman77

postsaurav,

almost there.. but i got an error:

This message is for C/AL programmers:

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

postsaurav

Hi,

can u active the debugger and send me the details at which point you are getting this error.

nikeman77

postsaurav,
Can i check the datatype of object to be used ? Initially when I used>> Microsoft Excel 12.0 Object Library & the Class (Workbook or WorkBookS)
I got this error >>
This message is for C/AL programmers:
Could not create an instance of the OLE control or Automation server identified by
GUID={00020813-0000-0000-C000-000000000046}
1.6:{00020819-0000-0000-C000-000000000046}:'Microsoft Excel 12.0 Object Library'.Workbook.
Check that the OLE control or Automation server is correctly installed and registered.

postsaurav

Hi,

Did excel and Navision are installed on the machine?

nikeman77

postsaurav wrote:

Hi,

Did excel and Navision are installed on the machine?

Yes, both are installed. Excel 2007, Nav V5 SP1, Windows 7 Professional, 64 Bit

postsaurav

Hi,

can you try using -

CREATE(XlApp,TRUE,TRUE)

as first line in the function and let me know the results.

nikeman77

postsaurav,

sorry for the late reply..
1.) Variable: XlApp is Automation, Microsoft Excel Object 12.0 with Classes= _Application ?
2.)Hit an error when i place my code first line of my delete function in my reports Post Report()
still same Error This message is for C/AL Programmers...

nikeman77

postsaurav wrote:

Hi,

can u active the debugger and send me the details at which point you are getting this error.

>> CREATE(XlApp,TRUE);

postsaurav

Hi,

2.)Hit an error when i place my code first line of my delete function in my reports Post Report()
still same Error This message is for C/AL Programmers...

Put the code not in report but in the table at the start of function.