vba - Word (2010) Update date and keep formatting using Macro -


i have following vba code insert date in format of code @ bookmark locations. inserting date each time open file without deleting old boookmark text added delete text @ top of code deletes format , inserts text there way keep formatting? 

    sub autoopen() ' ' autoopen macro ' '  activedocument.bookmarks("mydate").range.delete  activedocument.bookmarks("mydate1").range.delete  activedocument.bookmarks("mydate2").range.delete  activedocument.bookmarks("mydate3").range.delete  activedocument.bookmarks("mydate4").range.delete  activedocument.bookmarks("mydate5").range.delete  activedocument.bookmarks("mydate6").range.delete        activedocument.bookmarks("mydate").range          .insertbefore format(date + 1, "dddd dd mmmm yyyy")       end      activedocument.bookmarks("mydate1").range         .insertbefore format(date + 2, "dddd dd mmmm yyyy")     end      activedocument.bookmarks("mydate2").range         .insertbefore format(date + 3, "dddd dd mmmm yyyy")     end      activedocument.bookmarks("mydate3").range         .insertbefore format(date + 4, "dddd dd mmmm yyyy")     end      activedocument.bookmarks("mydate4").range        .insertbefore format(date + 5, "dddd dd mmmm yyyy")      end      activedocument.bookmarks("mydate5").range        .insertbefore format(date + 6, "dddd dd mmmm yyyy")     end      activedocument.bookmarks("mydate6").range         .insertbefore format(date + 7, "dddd dd mmmm yyyy")     end end sub

when 'formatting' mean date formatting, or bold/italic, etc?

in case, code doesn't run me; when delete range bookmark goes it. following runs me, , correctly formats dates each time run it:

dim temprng range  set temprng = activedocument.bookmarks("mydate").range temprng.text = format(date + 1, "dddd dd mmmm yyyy") activedocument.bookmarks.add "mydate", temprng  set temprng = activedocument.bookmarks("mydate1").range temprng.text = format(date + 2, "dddd dd mmmm yyyy") activedocument.bookmarks.add "mydate1", temprng  set temprng = activedocument.bookmarks("mydate2").range temprng.text = format(date + 3, "dddd dd mmmm yyyy") activedocument.bookmarks.add "mydate2", temprng

you can continue rest of bookmarks or throw whole thing in loop.


Comments

Post a Comment

Popular posts from this blog

Eclipse formatter for java ending braces -

i know if it's possible setup eclipse format braces using banner style. we're working code uses banner style formatting , keep consistent within team version control reasons. here's example of banner style formatting not familiar: public class foo { //------------------------ public static void main (string[] args) { boolean condition = true; try { if (condition) { system.out.println ("condition true"); } else system.out.println ("not condition"); } catch (exception ex) { // handle errors } } //------------------------ } update: name style ratliff. experiment java->code style->formatter preferences. "banner style" seems poor use of space given outline view , quick outline functionality.
Read more

ruby - Nesting modules inside of a Rails eninge gem -

what proper syntax nest child modules within parent module being isolate_namespace rails engine gem? # lib/myengine/engine.rb module myengine class engine < rails::engine isolate_namespace myengine # def ... end end for example. parent module myengine , child module blog. myengine share common domain, crud, taggable, searchable, etc, keep gem code dry , isolated main app (myapp), while inheriting isolated namespace , engine. are either of 2 approaches correct? refactor advice? # # lib/myengine/blog.rb module myengine module blog # def ... end end # b # lib/myengine/blog.rb module myengine class engine < rails::engine isolate_namespace myengine module blog # def ... end end end option a. correct, should lib/my_engine/blog.rb . can read more ruby & rails naming conventions here . further, if want put more modules or classes under blog namespace put them in folder lib/my_engine/blog , nest them under myengine::bl...
Read more

java - Are there any classes that implement javax.persistence.Parameter<T>? -

i'm using named queries fetch entities database using jpa , hibernate , came across puzzling me: how come there no default implementations of javax.persistence.parameter interface? i rather impressed how @staticmetamodel used criteriabuilder in jpa2 meaning type safety , don't have mess around setting string names. wanted apply similar of jpa1 ejb's i'm working on: dealergroup_.class: public dealergroup_ { public parameter<integer> id = new parameterimpl<integer>("id"); /// etc... } dealergroupfacade.class: // ... public dealergroup fetch(integer id) { typedquery<dealergroup> query = em.createnamedquery("dealergroup.fetchbyid", dealergroup.class); query.setparameter(dealergroup_.id, query); return query.getsingleresult(); } // ... i surprised find there no implementations of parameter interface - of course, implement myself absence makes me suspicious may mistake using in way? should implementing parameter...
Read more