Step by Step Macro Help.

G

Guest

Hello helpers!

I need to know how to perform a step by step Macro. This is what I would
like to do:
I have a folder on a shared drive and within that folder I have several
excel files that need to all go into a master excel file. All the excel
files have the same format and same headings. The master will look just like
the excel files except it will compile all the files into that one
spreadsheet (the master). This is where I need help. Can someone give me a
step by step process to use?
For Ex:
1)Go to Tools
2)Go to Macro --->Select Record New Macro
3).....

That is about all that I know. Do I have to select all the files in that
folder and do something else? I am so confused! I need this info ASAP as I
need to implement this first thing in the morning for my boss!!!!
 
N

NickHK

Miss Atlanta,
So start the recording, perform your actions and see the code that is
generated.

NickHK
 
T

Tom Ogilvy

Due to the urgency of the situation, it might be just as easy to go to each
file, open it, copy that data.
 
G

Guest

HOW? How would I get the files to all go into the master automatically? I
don't know the steps! Can someone tell me the steps???
 
G

Guest

Tom thanks for your help, but here it the thing. This process has to be
automated because it will be a daily function with about 80-100 files in the
folder that need to be compiled into the master. This is very urgent but I
just need to know how do you get the files to compile in to the master
automatically? Do I have to hold the ctrl key down and select all the files
and then do something else? What is that something else? Tom PLEASE HELP
ME!! Thank you in advance!!!!
 
N

NickHK

Miss Atlanta,
You are not going to have much success automating the process with VBA if
are not able to perform you routine manually.
Think about the Open..Copy/Move..Paste...Save...Close sequence that you will
have to achieve and record that.
See what you have and read about loops.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Go back to last step in programming 2
Run macro on all files in a specific folder 3
How to run Excel Macro on all files in folder 3
How to separate Excel Workbooks into new files 0
Step Into Macro when file opens 3
Macro fails from Tools menu, works when step through in VBA. 1
i need 1 macro button in master file to refresh data from all files 0
Macro step wasn't recorded 1

Top