James
|
| posted on 12/8/09 at 12:35 PM |
|
|
Viewing Excel Macro Code
I've got an old Excel based program that contains Macros.
You load it up in Excel, enable Macros if necessary, press Ctrl-M to run it.
In then asks a series of questions and you answer with ok or cancel. It adds up your score and tells you at the end.
I'd really like to view the actual program so I can see the questions and values for the various answers.
Presumably this is possible?
I've googled but not really successfully got an answer I can understand.
Anyone any good with Macros?
Thanks!
James
------------------------------------------------------------------------------------------------------------
"The fight is won or lost far away from witnesses, behind the lines, in the gym and out there on the road, long before I dance under those lights."
- Muhammad Ali
|
|
|
|
|
Mr Whippy
|
| posted on 12/8/09 at 12:49 PM |
|
|
The programming language that macro’s are written in is visual basic iirc
Fame is when your old car is plastered all over the internet
|
|
|
Humbug
|
| posted on 12/8/09 at 12:49 PM |
|
|
Go to the menu and do Tools->Macro->Macros, select one and click Edit
You can also do Alt-F11 then double click on Modules in the top left pane. That will open a pane on the right with all your macros
|
|
|
James
|
| posted on 12/8/09 at 01:43 PM |
|
|
Hmmm, well, I did that.
It only really allows you to go through the code 1 question at a time, whilst seeing the code. But without fully understanding the code I'm
slightly quessing at what it's saying.
I was hoping for a nice list of the questions with the associated answer/points in a nice table or something! 
------------------------------------------------------------------------------------------------------------
"The fight is won or lost far away from witnesses, behind the lines, in the gym and out there on the road, long before I dance under those lights."
- Muhammad Ali
|
|
|
Madinventions
|
| posted on 12/8/09 at 04:27 PM |
|
|
I spend all day writing VB code so if you want to send me the file I'll see if it can be rearranged for you?
Ed.
|
|
|
