Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,059
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing interop assembly... Editor Excel Discussion (Misc queries) 0 April 25th 07 09:48 AM
Print routine needed for code pano Excel Worksheet Functions 3 February 11th 07 02:27 PM
How to Reference a .Net Assembly from within VBA? TCook Excel Programming 2 October 31st 06 11:52 AM
How can I create a worksheet in a routine and set the code name at kataiwo Excel Programming 2 September 16th 06 04:12 PM
How to code a timer to trigger a sub-routine ? Joseph[_10_] Excel Programming 1 December 18th 03 12:48 PM


All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"