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

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

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

Postby sderrico » Thu Mar 22, 2012 1:02 pm

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!
Sebastien

Sébastien D’Errico
IT Development Consultant
Mobile : (438) 882-8687
Email : sebastien@hollox.net
sderrico
 
Posts: 1
Joined: Thu Mar 22, 2012 12:53 pm

Re: Open an XLS file with Macro, import defined name and sav

Postby Suvi.Wu » 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.
BR
Suvi
e-iceblue support
Attachments
Samples.zip
two demos about scenario A and secnario B
(45.43 KiB) Downloaded 237 times
User avatar
Suvi.Wu
 
Posts: 156
Joined: Thu Oct 20, 2011 2:53 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests