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

-----Original Message-----
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


.
If I understand your question just put the macro into the
PERSONAL.xls workbook. Then it will be available for any
worksheet.

Thanks,

Greg