View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can I see assembly code for VBA routine?

Your code isn't turned into assembly language or even compiled.

I _think_ Chip Pearson has a whitepaper describing how your code is transformed
into pCode--a symbolic code.

If you look he
http://www.cpearson.com/excel/ExcelPages.htm

You'll see a subject called "White Papers". Right now the link to the next page
doesn't work, but I've sent Chip an email. If he's around I would expect it
fixed pretty darn quickly.



joeu2004 wrote:

Is there some way that I can see the assembly code for a VBA routine?

I have Office Excel 2003 and the VBA that comes with it (VB 6.3), with
Windows XP Pro SP2 running on an Intel Pentium M 770.


--

Dave Peterson