English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

just wanna ask if that program is related with excel? if they are related in what way???

2006-08-11 09:35:04 · 3 answers · asked by ross_24 1 in Computers & Internet Software

3 answers

Macros are like small and simple programs that can be written within Microsoft excel. You can also think of them as scripts in excel. You can use macros to automate certain functions within excel.

2006-08-11 09:56:24 · answer #1 · answered by Grasshopper 4 · 0 0

The simple answer to your question is "yes".

A macro is a generic term meaning "a set of sequential instructions or commands". Many different programs and systems support macros, including Excel. Within Excel, there are two types:

1) Record macros - these are the ones you get by going to "Tools -> Macros -> Record New Macro" (on your version of Excel it might be different, I'm using Excel 97 at the moment). These macros work like a tape recorder, you press record and then do some action. For example, you might want to create a macro to change the format of a cell from "Date" to "Text". You record a set of commands and then assign a shortcut key so that you don't have to go through the menus each time.

2) Visual Basic macros - these are much more powerful. They are basically computer programs within Excel. You can write a visual basic macro to do almost anything, even control other parts of Windows. For example you can program a macro to access data from a Microsoft Access database, or create a new file. A Visual Basic macro in Excel has access to all the cells and sheets, and can manipulate them in ways that you cannot otherwise do just by using Excel.

I hope that answers your question.

2006-08-11 10:55:36 · answer #2 · answered by Anonymous · 0 0

http://tinyurl.com/161

2006-08-11 09:58:53 · answer #3 · answered by Anonymous · 0 0

fedest.com, questions and answers