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.

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 here:
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

It's Visual "Basic", an interpreted, not compiled, code.

"joeu2004" <(E-Mail Removed)> wrote in message
news:b3f8095f-d9b3-4d2d-b021-(E-Mail Removed)...
> 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.