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 programming language that macro’s are written in is visual basic iirc

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

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!

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.