macros - Outputting Drop-Down Form Field to String for use in VBA formula -

-

ok, have word 2010 template i'm playing with. have button @ top users click automatically save word doc pdf (almost) correct name, in correct directory, , opens doc. have drop-down form field can select month.

the code button:

private sub commandbutton1_click()     convert_pdf end sub   sub convert_pdf()   dim desktoploc string  dim filename string  dim date string  dim user string  dim mypath string      desktoploc = createobject("wscript.shell").specialfolders("desktop")     filename = "installs team metrics"     user = vba.environ("username")     mypath = desktoploc & "\metrics\" & filename & " - " & date & " - " & user      activedocument.exportasfixedformat outputfilename:= _         mypath, _         exportformat:=wdexportformatpdf, openafterexport:=true, optimizefor:= _         wdexportoptimizeforprint, range:=wdexportalldocument, from:=1, to:=1, _         item:=wdexportdocumentcontent, includedocprops:=true, keepirm:=true, _         createbookmarks:=wdexportcreatenobookmarks, docstructuretags:=true, _         bitmapmissingfonts:=true, useiso19005_1:=false end sub

this outputs file c:\users[username]\desktop\metrics\installs team metrics - [month] - [username].pdf

biggest problem is, cant figure out how whats selected in dropdown box string "date". have feeling i'm using wrong 1 (pretty sure need activex control one) i'm new vba , appreciate help.

looks content control rather legacy field, need

activedocument.contentcontrols(i).range.text

where index no. of control (the first 1 in document 1, etc.)

so either need know number, or need use title or tag of control (or else) identify control. in case of content controls, have iterate collection find it, e.g.

dim cc contentcontrol each cc in activedocument.contentcontrols   if cc.tag = "mytag"     strdate = cc.range.text     exit   end if next

be careful how title/tag controls. word not enforce uniqueness of either titles or tags.

another way create custom xml part "date" element , connect control using xpath. can retrieve value directly custom xml part , don't need know control itself. think in simple form adds complications can without.


Comments

Post a Comment

Popular posts from this blog

java - Jmockit String final length method mocking Issue -

-
using jmockit 1.2 jar, trying mock string's length method getting unexpected invocation exception: failed: test java.lang.illegalstateexception: missing invocation mocked type @ point; please make sure such invocations appear after declaration of suitable mock field or parameter @ stringdemo.testa$1.<init>(testa.java:17) @ stringdemo.testa.test(testa.java:13) i using testng: @test public void test() throws exception { new expectations() { @mocked("length") string astring; { astring.length(); result = 2; } }; system.out.println(a.showa("test")); } } actual class a: public class { public static int showa(string str){ int a= str.length(); return a; } } this wrong way of recording expected results. shouldn't mock , record string's length() method, record showa() instead. here solution @suppresswarnings("unused...
Read more

What is the difference between data design and data model(ERD) -

-
i have google question , find answer in day. know, data design many many table have list column,and mark pk , fk. why er-diagram have find this? data design process of designing database. main output of data design detailed logical data model of database. some people data design includes of needed logical , physical design choices , physical storage parameters needed generate design in data definition language. technically, database analysis, database analysts (dbas) trained do. while person can both data design , database analysis, these 2 different tasks. data design models data. database analysis takes model , applies 1 or more database engines (relational, hierarchical, nosql). a logical data model 1 of main outputs of data design. data model represented entity relationship diagram, or er diagram.
Read more

ios - Can NSManagedObject conform to NSCoding -

-
i need transfer single object across device. right converting nsmanagedobject dictionary , archiving , sending nsdata. upon receiving unarchiving it. transfer nsmanagedobject archiving , unarchiving instead of creating intermediate data object. @interface test : nsmanagedobject<nscoding> @property (nonatomic, retain) nsstring * title; @end @implementation test @dynamic title; - (id)initwithcoder:(nscoder *)coder { self = [super init]; if (self) { self.title = [coder decodeobjectforkey:@"title"]; //<crash } return self; } - (void)encodewithcoder:(nscoder *)coder { [coder encodeobject:self.title forkey:@"title"]; } @end nsdata *archivedobjects = [nskeyedarchiver archiveddatawithrootobject:testobj]; nsdata *objectsdata = archivedobjects; if ([objectsdata length] > 0) { nsarray *objects = [nskeyedunarchiver unarchiveobjectwithdata:objectsdata]; } the problem above code is. crashes @ self.title in initwithcoder sa...
Read more