Create excel macro

[leekn23]

After I export a report into an excel file, I need to create a macro inside that excel file so that someone can use it to approve it. (After reviewing it, they will use a shortcut key like "Ctrl + M" and in the top of the excel file will said approved date - today's day). Can anyone please show me how to do so?

 

[mosfin]

you should create Excel template (.xlt) file, which already includes
your macro, then in your progress code you open the Excel template
usin COM-HANDLE, and insert your report output data
(you can find many examples here in ProgressTalk, just use search)

 

[leekn23]

Thx alot mosfin
I'll give it a try and see

I have one more question
Is there anyway I can copy a macro from one excel to another?

 

[Osborne]

Although I have never tried this I think it can be done using the VBComponents Export and Import options. An example can be found here:

http://www.mrexcel.com/articles/copy-vba-module.php