Automation of report, daily, monthly then yearly as per need
 

Hi all:
I have to record an excel macro for an automation of a report
generating process. This has to be in a dot net framework.

Here is what I did:

I opened the an excelworksheet, record a macro and gave a name.
I did save the worksheet (with macro written)
I created a button and assign the above macroname

I did some excel macro couple of years ago, but now kinda getting
confused.

Questions:

How I can create the button with my macro in other users cpu so they
can click and get the desired result.

I could not integrate the populating the date of said report in my
assigned macro.

I wonder how I am gonna make it in a dot net frame.

I am sort of lost at this time, hope someone will show me the rope to
climb this rocky hill

The Other IT GUY