Excel VBA to Word bookmark with Excel cell format retained -


i have vba code snippet extracts excel cell data word template, using bookmarks in template assign values specific template locations. able export excel cell values in text format bookmarks, cannot retain native excel formatting.

the code uses .value property extract data in text formatting. i'm trying minimize manual formatting second time in word (converting text exported value of 150001.22 dent_90 excel range $150,001.22 dent_90 bookmark in word, example).

any idea on how might done, such can export word using excel currency cell formatting? i've looked @ explanations formattext, can't seem work following snippet:

sub testmemogen() dim objword object dim ws2 worksheet  application.screenupdating = false set ws2 = thisworkbook.sheets("word export") set objword = createobject("word.application") objword.visible = true objword.documents.open "c:\users\ tester\word test sim.docm"  objword.activedocument .bookmarks("dent_90").range.text = ws2.range("dent_90").value end set objword = nothing application.enableevents = true end sub

thanks , suggestions. have hundred bookmarks linked different templates, huge if formatting can exported natively excel.

.value "text" of cell, in case number. doesn't carry formatting info it. need numberformat.

<some number>  = ws2.range("dent_90").value <the format>   = ws2.range("dent_90").displayformat.numberformat

a little test shows:

sub junk()     msgbox "format=" & application.range("g2").displayformat.numberformat     end sub

so, info excel cell "format=#,##0".

in word doc, can use format() described above scott, or at: https://msdn.microsoft.com/en-us/library/office/gg251755.aspx

as side note, did know can try things , record functions in macro go? then, @ recorded macro see how things, perhaps formatting text entered, gives little more control on precise formatting...


Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more