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