I tried to copy from word using VBA.
In excel I have formatted the values like dates as Nov 20 but when it gets pasted to word it changes back to 1-Nov-20
How do i maintain the text formatting on word OR copy from excel as values
I tried to copy from word using VBA.
In excel I have formatted the values like dates as Nov 20 but when it gets pasted to word it changes back to 1-Nov-20
How do i maintain the text formatting on word OR copy from excel as values
Last edited by saravnepali; 09-10-2020 at 07:19 PM.
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
Attaching sample files will probably help.
The Excel file with the code used to copy, and the Word file, both stripped of all sensitive data.
I've inserted dates from Excel into Word bookmarks without problems and just the way date was formatted in Excel. I don't see why copy / paste would get different dates in Word.
To show your appreciation
Click ★ Add reputation!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks