View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[sven] [sven] is offline
external usenet poster
 
Posts: 1
Default date display from excel in word

Hello all,

I'm working on a macro wich must look for people,dates,currency.. and so on
in a big table, so the selected data are placed in a smaller table, from
wich a word macro (activated by a cmdbutton in excel) uses tha data to make
a mail merge. The selected data is used to write 25-50 letters a time
without having to type :-)

All works well, and as it should, only the date (as in: 12/05/2006) is
displayed as a number ( wich excel uses..) so i don't have date's in my
letters but things as "38849". Not very usefull.. can anybody tell me how
to display the excel date as a date in word ?

I already tried with automated copy-paste, that works, but only very
slowly. I also tried to automate copy and paste in a texbox in excel..that
doesn't work, because i can't paste in a texbox..any ideas ?

tia
sven