Calling a macro from ActiveX Script.
 

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

Calling a macro from ActiveX Script.
 

Depending on the scope and definition of 'activex script'..

You can access a macro from 'outside' of the XL workbook containing it
with the Application.Run method. You can even access it with a similar
technique from outside of XL (assuming you are automating XL). In any
case, you should also parameterize the macro so that it accepts as an
argument the range it should operate on.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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