Blue Eye Macro
http://blueeye-macro.com/

VBA Macro changing macro
http://blueeye-macro.com/viewtopic.php?f=9&t=27823
Page 1 of 1

Author:  picture1984 [ Fri Jun 10, 2016 2:40 pm ]
Post subject:  VBA Macro changing macro

Is it possible to create a macro in MS Office (in this case Word) that will change other macro code? I was trying to find information but no results.

I have a doc which works as a template. Content of template is changed and then saved to another file. However it is important to have current date in it. It cannot be self-updated. Those docs go to folder of people and it is important to know when they get the document, so it must be simply data (or something that does not update).

I was thinking about an on-start event macro that would input current date and on exit it would ask "Do you want self-update functionality" Yes / No

If Yes, delete that event. However I have no idea if it is possible. If it is I still don't know how to search for it.


Thanks for looking.
______________________________________________________nha khoaimplant
Any ideas would be appreciated
implant , nha khoa Nhân Tâm, mini implant, Implant nâng đỡ cầu răng

Author:  Syrifina [ Fri Jun 10, 2016 8:26 pm ]
Post subject:  Re: VBA Macro changing macro

Quote:
Is it possible to create a macro in MS Office (in this case Word) that will change other macro code?
You should ask that question on a Microsoft forum.

You can do everything you said with a BEM macro, but I don't know about the macro system within Word. I've never been able to get any good functionality out of the macro systems in Office, unless you script everything out in Visual Basic...but this isn't the forum for that. Besides, it's easier and much faster to do with BEM.

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/