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 ?