Open an XLS file with Macro, import defined name and saveas

[sderrico]

Hello,

I need to create an application in VB.NET that:
1) open an excel files: source
2) open another excel file: target
3) import the defined name from source to target
4) save the file as a third excel file: output

Scenario A:
1) The user open source.xlsx (2007)
2) Open target.xls (2000)
3) Import defined name
4) save the result as output.xlsx (2007)

Is Spire.XLS support macro? We do not want to manipulate them. Just keep them if there are in the target file.

Scenario B:
1) The user open source.xls (2000)
2) Open target.xls (2000 that contain a macro)
3) Import defined name
4) save the result as output.xls (2000 that keep the macro)

Thank you,
Have a great day!

[Suvi.Wu]

Hi Sebastien,

Thanks for evaluating Spire.XLS.

Spire.XLS can read and keep the macro, but can't support to create a macro. So Spire.XLS can meet all your requirements perfectly. I attached a zip file including two demos about the Scenario A and Scenario B. Please have a look.

If you still have any questions,please feel free to contact us.

Have a nice day.
BR
Suvi
e-iceblue support