Programming a console application

  • Thread starter Thread starter Bilal A F
  • Start date Start date
B

Bilal A F

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
Click to expand...
PERSONAL.xls workbook. Then it will be available for any
worksheet.

Thanks,

Greg
 
Back
Top