Blue Eye Logo

Blue Eye Macro

Automation is freedom
It is currently Fri Jan 20, 2017 10:00 pm

All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: VBA Macro changing macro
Thanked: 0 time(s)  Unread post Posted: Fri Jun 10, 2016 2:40 pm 
New User
New User



Joined: Sat Jun 28, 2014 6:01 pm
Posts: 5
Location: Mexico
Been thanked: 0 time(s)
Has thanked: 0 time(s)
Contribution Points: 10
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


Top
 Profile  
Reply with quote  
 Post subject: Re: VBA Macro changing macro
Thanked: 0 time(s)  Unread post Posted: Fri Jun 10, 2016 8:26 pm 
Partner / License admin
Partner / License admin
User avatar



Joined: Sun Oct 10, 2010 5:16 pm
Posts: 1586
Location: USA
Been thanked: 339 time(s)
Has thanked: 25 time(s)
Contribution Points: 15594
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.

_________________
----------------------------------------Syrifina---------------------------------------------------
PM me for licenses and/or licensing information: Click Here
[Be sure to include and update your profile with your BE ID]

Forum Rules
Reminder of rules regarding Contribution points
Getting started in 1, 2, 3
Virtual Drivers; Manual Installers


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


You cannot post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group