Recording a macro

[Denise Payne]

I am using Excel.
What I am trying to do is use a Command Button to link to a macro that will
open a speadsheet from another file(Spreadsheet 1), then update another
spreadsheet(Spreadsheet 2) from the first spreadsheet. Then, close
everything. It is modeling data and there are 4323 rows and 50 columns. I am
trying to create a command on one spreadsheet that will update the data at
the touch of a button.

 

[Denise Payne]

I recorded the macros, but they do not appear to be running. For instance,
the first macro I recorded was Open099UPDATE which is a .xls file. The way I
recorded the macro was this way:
1. I opened Tools, Macro, Record
2. Then I clicked through the steps to open that spreadsheet.
3.I clicked Stop Recording
Now, when I ran the macro, nothing happened.
What did I do wrong?

 

[Joel]

The best way of determining what is happening is to add break points and step
through codce. Press ALT F11 to view code. Click on first line of macro and
press F9. You should be able to go to the speadsheet and start macro as you
did before. The macro should stop on 1st line of code. You can Press F8 to
step through macro or add more break points using F9 and run code by pressing
F5. This shoudl get you started. for simple macros. Find out where the code
stops running.

 

[Don Guillett]

Post your coding efforts for comments