Excel duplicate

grilli

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

kapamarou

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

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 .. .