how can i delete a row?

vijaydidmca2003

hello to all mibuso members.

i have little problem.

how can i delete a row form excel sheet by using coding in navision?

thanks. #-o

epernst

Exactly what do you want to do? Is this spreadsheet created by NAV?

Belias

You can use excel, record a macro, delete a line and take a look to the code that is generated in VB excel.
then, try to adapt it to nav automation...anyway, it should be something like this.

XlApp.Range('A1').EntireRow.Delete;

P.S.: search the forum...i think you will find about 20k posts about excel

Savatage

I think eric was going for...

If it's created in nav why not filter out the line so it never get's exported in the first place..
So I agree more info is needed.

Belias

Savatage wrote:

I think eric was going for...

If it's created in nav why not filter out the line so it never get's exported in the first place..
So I agree more info is needed.

:-k maybe i read this topic too...."literally"