Export a Sub to Excel

DasChamaeleon
DasChamaeleon Member Posts: 4
in NAV/Navision Classic Client
Hey there.
Maybe I wont get help to my other topic so I just try to find an alternativ solution.
How do I export an VBA-Code to Excel while using the standard funktion (CTRL+E in a List Page) to export to excel.

I would like to export following code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Tabelle1.Columns("A:Z").AutoFit

End Sub


Greets

Answers

  • Jan_Veenendaal
    Jan_Veenendaal Member Posts: 206
    The only way I can think of is adding this sub to your default template for Excel - but I'm not sure that will be used when Excel is opened from NAV.

    Jan Veenendaal
    Jan Veenendaal

Categories