ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I see assembly code for VBA routine? (https://www.excelbanter.com/excel-programming/404406-how-can-i-see-assembly-code-vba-routine.html)

joeu2004

How can I see assembly code for VBA routine?
 
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

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

Net Doe

How can I see assembly code for VBA routine?
 
It's Visual "Basic", an interpreted, not compiled, code.

"joeu2004" wrote in message
...
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.





All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com