Right now: Live recording of the Tech Support Guy Show!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express php pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
DOS/PDA/Other
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Operating Systems > DOS/PDA/Other >
Need Help!


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
j_vincent_01's Avatar
Junior Member with 3 posts.
 
Join Date: Oct 2003
11-Dec-2003, 01:23 AM #1
Need Help!
Hello!
Greetings!
I need some help from you. And could you please help me in the these following questions:

What is an Excel macro?
What types of tasks can a batch file or macro perform?
What are the benefits of using batch files and macros?
What are the drawbacks of using batch files and macros?
colman77's Avatar
Senior Member with 597 posts.
 
Join Date: Jun 2002
Location: New Hampshire
Experience: Intermediate-Advanced
14-Dec-2003, 08:23 PM #2
j_vincent,

A macro/batch file, in general, is simply a list of commands...a sort of mini program.
If you use excel frequently, macros are very helpful. You can make a macro to do just about anything in excel, but for the most part they're best used to format spreadsheets. For instance, you could make a macro to resize column A and B to some size, put a title in row 1, put in standard values for cells b2-b6, and save the spreadsheet as important.xls.
Basically, the upside to using a macro is that is saves time in the monotonous formatting of spreadsheets.
The downside to using a macro is... I don't know, but I bet there's a few.
__________________
The Granite State... We Rock!
------------------------
Dude, I got a Dell!

FIRST Robotics - AMAZING, for any high schooler who likes technology!!
zephyr's Avatar
Distinguished Member with 2,386 posts.
 
Join Date: Nov 2003
Location: Southern California, USA
14-Dec-2003, 09:00 PM #3
Batch files and macros can allow someone who is well versed in their use to create a way for people less versed to do things that would not ordinarily be possible for them. That allows them to be productive with less training.

One of the drawbacks is that it actually keeps some people from ever learning and advancing in the field.

Another drawback is, sometime a macro cannot be converted across to another platform (such as QuattroPro to Excel) and some usability of the item suffers as a result.

You really should study the course material instead of getting assistance from a help forum.

Good luck.
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 11:10 AM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.