Too many questions in there.

I suggest you record a macro that does the basic job, open file 1, open file
2, merge the data, graph it. Then break it down into its separate parts, and
decide which bits you want changed. If you have difficulty, post again with
a specific question, details, and code.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Venkataraman.P.E" wrote in
message ...
Hi, I'am interested in creating Macros for some job tasks of mine. I went
through the Excel course of "Working with Loops" in Macros and have
attained
some basic information on VBA. But since I'am not an expert in it, I want
to
create Excel macros, using the Option " RECORD MACRO" in excel. My problem
is
that, I want the MACRO to (a) Copy data from 2 files into a new file. (b)
Analyze this data with calculations (c) Build a graph.......basically the
summary sheet and graph in a new sheet of the new file. I want to know,
whether, can we do such a macro using "RECORD" feature? But I did try. I
was
stuck when I had to open 2 different files........I want the MAcro to
prompt
MssageBox as " Open the Last Month File" and.....then " Open the current
month file" and so on..............But this is somehow not possible
without
VBA scripting........but I have learnt how to insert a Message Box, using
"MsgBox" command. But this box should have a space to browse and select
the
files......which I'am not aware of how to do it........Can you kindly help
me
out by suggesting me on the above, point by point ...of how I should be
able
to do it? And also if possible suggest me the link in MS Ofice Online to a
course on Macros that will help me gain knowledge on the above ?