Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

can anyone give me any links (from internet) which explain more about macro in excel?

  Asked By: Idelia    Date: Aug 28    Category: MS Office    Views: 1185
  

I have some problems about using Excel;
1. I work with a lot of worksheet and many files.
questions: how to make a compilations file from many worksheet with
many files ( with macro's code)

2. can anyone give me any links (from internet) which explain more about
macro in excel?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Sumitra 2004     Answered On: Aug 28

You might want to start with the articles listed here:
pubs.logicalexpressions.com/.../LPMFrame.asp
TH=33

 
Answer #2    Answered By: Betty White     Answered On: Aug 28

For #1, you can turn on the macro  recorder, then do some manual
compilation by opening files, cutting, pasting, and so on. Then
examine the recorded macro to see what commands are involved. Then
you can try to modify the macro.

For #2, try:
http://www.j-walk.com/ss/excel/index.htm
msdn.microsoft.com/isv/technology/vba/default.aspx
and search the web using Google or Yahoo

 




Tagged: