Reverse Engineer Code?

[cranebill]

I have been learning vba on a "need to know" basis meaning if i need something written i figure it out as i go.. Well I am running into alot of examples of coding now that calls API's and all other sorts of things I really havent seen before. What is the best way I guess to reverse engineer code so I can get a better understanding of what is going on rather that just having no idea whats going on and changing a value or two to make it semi-work for my application.

Hope that made sense.

Bill

 

[psemianonymous]

For every built-in method, there are good (internal) help files. Go to the method in question and hit F1.

For the external API calls, you can search Google and/or Google Groups for specific descriptions.


Between these two things I've done the bulk of my Access-specific learning.

 

[rdodge]

I'm not so sure about reverse engineering type deal for learning how to work with API's, but here's a link to Windows APIs with a list of a lot of the different API's. However, be aware, some APIs may not work as expected within VBA as the API's are setup to use C/C++ programming.

http://msdn.microsoft.com/library/en-us/winprog/winprog/windows_api_reference.asp

Main thing though is to get a thorough understanding of how VBE/VBA works with the varoius ways of programming, debugging tools (including knowing how to debugging in different ways for different types of programming challenges), and there may be a few other things that I may have left out.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.