Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting daily data into weekly, monthly and yearly data CEGavinMcGrath Excel Discussion (Misc queries) 4 April 3rd 23 06:54 PM
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET mike64149 Excel Discussion (Misc queries) 4 September 22nd 08 08:11 PM
How can I add "monthly" tabs that summarize a yearly report? eg2008 Excel Worksheet Functions 3 May 17th 08 02:31 PM
spreadsheet for tracking reports daily, monthly, yearly and graph Kompare Excel Worksheet Functions 2 April 6th 06 09:28 PM
monthly/yearly expence by vendors Nikki New Users to Excel 1 February 5th 06 08:04 PM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"