View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Kind of embedded macro

Hi Svedbo Active,

I have detected a few functions in VBA that doesn't work properly when
upgrading from 2000 to XP.


I am aware of post-XL2K features which are not available in earlier
versions; I am not aware of the reverse. What are these functions?

My question is therefo Is it possible to write a "macro that
manipulates another macro"?

Or do I need to write that in another programming language?


See Chip Pearson's 'Programming to the VBE ' page at:

http://www.cpearson.com/excel/vbe.htm




Regards,
Norman



"Svedbo Active"
wrote in message
news:Svedbo.Active.1twiag_1124269536.6661@excelfor um-nospam.com...

I have detected a few functions in VBA that doesn't work properly when
upgrading from 2000 to XP. So, I have this template with quite a few
macros in it, which I have corrected to work properly in XP.

Now, I have used this template for quite some years and therefore have
older excelsheets, that do not work now when I have upgraded to XP.

So instead of manually correct each file, I am thinking of writing some
kind of macro that automatically detects and changes the lines that
needs to be corrected.

My question is therefo Is it possible to write a "macro that
manipulates another macro"?

Or do I need to write that in another programming language?


Cheers


--
Svedbo Active
------------------------------------------------------------------------
Svedbo Active's Profile:
http://www.excelforum.com/member.php...o&userid=26366
View this thread: http://www.excelforum.com/showthread...hreadid=396385