Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default VBA in Excel to read the VBA Code

Hello:

Is it possible for Excel/VBA to 'read' and display it's own macro /
VBA code?

Let me ask/explain via an example:
My code has a tutorial section in which I would like to have the
tutorial retrieve the macro or button code and display that code it in
a text box.

Thank in advance,
TomC
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default VBA in Excel to read the VBA Code

Depending on security settings (set by each user), it could be possible using
some of the code at Chip Pearson's site:
http://www.cpearson.com/excel/vbe.aspx

Personally, I'd just copy|paste the code to a worksheet and then hide that
worksheet.



tomcee wrote:

Hello:

Is it possible for Excel/VBA to 'read' and display it's own macro /
VBA code?

Let me ask/explain via an example:
My code has a tutorial section in which I would like to have the
tutorial retrieve the macro or button code and display that code it in
a text box.

Thank in advance,
TomC


--

Dave Peterson
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
How can I make Excel read a value from a textfile and assign it to a variable in my VBA code?? haakon Excel Programming 2 February 28th 07 09:21 AM
Read Undo list in Excel 2003 using Csharp code Rana Saha Excel Programming 0 June 1st 06 06:59 PM
VB Code to 'read' .txt files and display info in Excel Petitboeuf[_4_] Excel Programming 1 December 19th 05 03:55 PM
Read out VBA code from a damaget excel.xls workbook. Øyvind Excel Programming 4 October 10th 05 01:20 PM
Open Excel file as Read Only with code, yogendra joshi Excel Programming 1 May 13th 04 03:46 PM


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

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

About Us

"It's about Microsoft Excel"