Excel duplicate

grilli
grilli Member Posts: 33
edited 2009-11-18 in NAV/Navision Classic Client
Hello everyone,

I need to know how I can make a copy of an existing excel, which lies on a route and do on this new document some modifications.

Thanks

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    Can you be more specific? What type of modifications?


    You could use the Excel Buffer Table to read an Excel file and then create a new workbook from this table as if you had filled the buffer yourself.
    Or you could use the Excel automation directly and do whatever you need.

    I would first try with the excel buffer to see if it fits my needs.
  • JPHSC
    JPHSC Member Posts: 67
    Something like this ?

    COPY('oldpath\oldexcel.xls', 'newpath\newexcel.xls');
    if you want to open the excel for the user, you can try :
    HYPERLINK('newpath\newexcel.xls');
    otherwise you will have to use automation .. .

Categories