ymrpttr
08-29-2016, 02:40 PM
I am using an excel worksheet and using VBA to access a .dot template. Both files have the bookmarks, data is transfered correctly. I am using placeholder bookmarks, the one that looks like a beam I.
My only problem is how to get the correct format in the Word document.
Example: The bookmark in excel shows 0.71 however the bookmark in word is displaying 0.712669683257918.
How can I get the bookmark to display only 2 decimals in word or exactly display the same value and format as the bookmark in excel?
Below is the code in the macro for reading and sending the value in the bookmark.
dottempplate.Bookmarks(xlName.Name).Range.Text = Range(xlName.Value)
Thanks
Yomero
My only problem is how to get the correct format in the Word document.
Example: The bookmark in excel shows 0.71 however the bookmark in word is displaying 0.712669683257918.
How can I get the bookmark to display only 2 decimals in word or exactly display the same value and format as the bookmark in excel?
Below is the code in the macro for reading and sending the value in the bookmark.
dottempplate.Bookmarks(xlName.Name).Range.Text = Range(xlName.Value)
Thanks
Yomero