Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a macro
I take it from the below that you have the macro already complete? If you
just need a command button try going to View-ToolBars and then select the formatting toolbar. Once that comes up as long as the bar has not been changed the sixth button from the left should be a button to insert a command button. Just click it select where you want the button. once the button is on the sheet just double click it. That will open VBA Editor and show an on click event for the button. Put the name of your macro in the Sub that was created and your button should now execute the Macro that you recorded. Denise Payne wrote: 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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200808/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a macro
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? -- Denise Payne "dustinbrearton via OfficeKB.com" wrote: I take it from the below that you have the macro already complete? If you just need a command button try going to View-ToolBars and then select the formatting toolbar. Once that comes up as long as the bar has not been changed the sixth button from the left should be a button to insert a command button. Just click it select where you want the button. once the button is on the sheet just double click it. That will open VBA Editor and show an on click event for the button. Put the name of your macro in the Sub that was created and your button should now execute the Macro that you recorded. Denise Payne wrote: 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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200808/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a macro
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. "Denise Payne" wrote: 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? -- Denise Payne "dustinbrearton via OfficeKB.com" wrote: I take it from the below that you have the macro already complete? If you just need a command button try going to View-ToolBars and then select the formatting toolbar. Once that comes up as long as the bar has not been changed the sixth button from the left should be a button to insert a command button. Just click it select where you want the button. once the button is on the sheet just double click it. That will open VBA Editor and show an on click event for the button. Put the name of your macro in the Sub that was created and your button should now execute the Macro that you recorded. Denise Payne wrote: 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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200808/1 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a macro
Post your coding efforts for comments -- Don Guillett Microsoft MVP Excel SalesAid Software "Denise Payne" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
Recording Macro | Excel Worksheet Functions | |||
Recording macro | Excel Programming |