Hi,

Is there a way to convert a VBA-macro in EXCEL to a separate console
application in VB which can be called and run on a particular excel
sheet.without having to open a different excel file every time copy paste a
macro and run again.

I am beginner in Visual Basic. How would I acheive this if i write a console
application in VB, it seems like EXCEL local objects and method are unknown
to VB compiler if I straight forwardly copy the macro. The second thing is
how do i open and EXCEL application program from my console application and
then open the related file and then run the code which do the formatting,
What libraries do i need to do a succesful compilation

Any help would be appreciated

Thanks
Bilal