Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 24th 05, 07:25 AM
zameer_india
 
Posts: n/a
Default About Macros


Hi .. All..

i am a S/W Test Engineer. Actually I have a new job on macros(my boss
gave me).
I don't know all the functions of macros. I just know that these are
used for Short cut keys (just like automation)...

I would like to know

1. What are the additional functions of Macros?

2. How these macros are used in Other Addin like VB Applications.... ?

3. If I have a Excel Template Then How can I use These templates in
Macros Programming?

4. How to write code (For macros) to access the data from VB
Application and produce reports in form of charts ,and reports.

Any help/suggestions/articles would be appreciate.

Thanx in Advance.




--
zameer_india
------------------------------------------------------------------------
zameer_india's Profile:
http://www.excelforum.com/member.php...o&userid=24559
View this thread: http://www.excelforum.com/showthread...hreadid=381869


  #2   Report Post  
Old June 24th 05, 07:28 AM
mangesh_yadav
 
Posts: n/a
Default


You might find some answers on this site:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=381869

  #3   Report Post  
Old June 24th 05, 08:46 AM
zameer_india
 
Posts: n/a
Default


Thanq Mangesh jee..

U helped me a lot in both forums .... I am really apprecited you...


--
zameer_india
------------------------------------------------------------------------
zameer_india's Profile: http://www.excelforum.com/member.php...o&userid=24559
View this thread: http://www.excelforum.com/showthread...hreadid=381869

  #4   Report Post  
Old June 24th 05, 09:11 AM
mangesh_yadav
 
Posts: n/a
Default


Thanks for the feedback.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=381869

  #5   Report Post  
Old June 24th 05, 11:59 AM
CLR
 
Posts: n/a
Default

A "Macro" is an abbreviation for a set of commands, so instead of typing a
complicated sequence of commands you can simply type the Macro's name. You
can either think of Macros as new commands in their own right or as
subroutines.

Virtually anything that can be done by hand in Excel, can be written into a
"Macro" so one can only invoke the Macro when they want that particular list
of commands instead of having to type each one each time.

Vaya con Dios,
Chuck, CABGx3
"zameer_india"
wrote in message
news:[email protected] m-nospam.com...

Hi .. All..

i am a S/W Test Engineer. Actually I have a new job on macros(my boss
gave me).
I don't know all the functions of macros. I just know that these are
used for Short cut keys (just like automation)...

I would like to know

1. What are the additional functions of Macros?

2. How these macros are used in Other Addin like VB Applications.... ?

3. If I have a Excel Template Then How can I use These templates in
Macros Programming?

4. How to write code (For macros) to access the data from VB
Application and produce reports in form of charts ,and reports.

Any help/suggestions/articles would be appreciate.

Thanx in Advance.




--
zameer_india
------------------------------------------------------------------------
zameer_india's Profile:

http://www.excelforum.com/member.php...o&userid=24559
View this thread: http://www.excelforum.com/showthread...hreadid=381869





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
Deleting Macros Mike Excel Worksheet Functions 2 May 25th 05 04:54 PM
sharing macros fabulousk Excel Discussion (Misc queries) 3 March 7th 05 10:05 PM
Enabling macros Peter M Excel Discussion (Misc queries) 3 February 7th 05 10:57 PM
sorting with macros Sorting in macros Excel Discussion (Misc queries) 1 February 1st 05 09:02 AM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 12:21 AM


All times are GMT +1. The time now is 10:42 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017