Run an xls macro and apply it on a particular xls file 1

[torturedmind]

[tt]Hi all. I just wanted to ask something about Excel automation. How can I run a macro recorded in MSExcel 2000 and apply that macro to an xls file exported from vfp6? I also need to run the macro from within vfp6.

Thanks in advanced.[/tt]

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."

 

[Mike Lewis]

Hi Kilroy,

To run a macro programmatically from within VFP:

loExcel = CREATEOBJECT("Excel.Application")
...
...
loExcel.Run("MyMacro")

You might need to qualify the macro name with the name of the workbook (e.g. "MyWorkBook!MyMacro").

I'm not sure what you mean about applying the macro to a file exported from VFP. You can apply a macro to any workbook. It doesn't care whether the file came from VFP or anywhere else.

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[torturedmind]

Thanks Mike for the very quick response. Am gonna try it later.

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."