Spire.XLS is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Thu Mar 22, 2012 1:02 pm


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!

Sébastien D’Errico
IT Development Consultant
Mobile : (438) 882-8687
Email : sebastien@hollox.net

Posts: 1
Joined: Thu Mar 22, 2012 12:53 pm

Fri Mar 23, 2012 11:53 am

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.
e-iceblue support
two demos about scenario A and secnario B
(45.43 KiB) Downloaded 383 times
User avatar

Posts: 154
Joined: Thu Oct 20, 2011 2:53 am

Return to Spire.XLS