I have a excel file which I use as a source file for my data import in sql
sever.
One column of this excel file has all email ids and all are as hyperlinks. I
need to remove these hyperlinks and just import the email ids to the
database.

I have a macro which removes the hyperlinks and just keep email address. I
need to run this macro programatically with out user interference. So I need
to have this macro separately and call this on which ever excel file becomes
my source file.

Any way to do this in ActiveXscript.

Thanks and Regards,
Karunakaran