Jump to content


Photo

Macro to transfer excel fields into word fields


Old topic!
Guest, the last post of this topic is over 365 days. Only Star PT contributors are allowed to post to posts this old.


  • This topic is locked This topic is locked
3 replies to this topic

#1 Blinker920

Blinker920

    New Member

  • Members
  • 4 posts

Posted 16 March 2011 - 07:14 PM

Hi,

I need a macro to automatically transfer contents of excel spreadsheet e.g. Patient Number, Name, Date of Birth, Referring Physician's Name, etc. from MS excel 2003 spreadsheet into the fields of MS Word 2003 for preparation of the reports. Can that be done and if so if someone can share macro or suggest an easier way than typing the fields all over.

Thanks,

Blinker 920
  • 0

716

#2 Ed Weber

Ed Weber

    Grand Vizier of Visual Basic

  • Star PT Contributor
  • 1,444 posts
  • Gender:Male
  • Location:Kentucky

Posted 17 March 2011 - 03:47 AM

Yes, a macro could be written to do what you want but it would be complex enough that you shouldn't expect anybody to program this without payment. I am too involved with other work to do the programming.

If you decided to hire a programmer you will have to provide a great amount of additional information. Also, the word "field" has very specific meanings in both Word and Excel so use the word carefully when describing what you want.

Your best approach might be to split the screen horizontally with Word at the top and Excel at the bottom then copy and paste from Excel to Word.
  • 0

#3 14tonks

14tonks

    Moderator

  • Forum Leader
  • 4,504 posts
  • Location:NYC

Posted 17 March 2011 - 07:20 AM

If you're doing this to generate a report, is there some reason you can't just use the Excel spreadsheet as the source for a mail merge, set up your Word merge document with the merge fields formatted as you want them, and then just let 'er rip whenever you need a report, setting the merge criteria for the date field, first and last name fields, or whatever you might need to use in order to specify which record/s from the spreadsheet to produce the merge output for?

#4 Blinker920

Blinker920

    New Member

  • Members
  • 4 posts

Posted 20 March 2011 - 10:58 AM

If you're doing this to generate a report, is there some reason you can't just use the Excel spreadsheet as the source for a mail merge, set up your Word merge document with the merge fields formatted as you want them, and then just let 'er rip whenever you need a report, setting the merge criteria for the date field, first and last name fields, or whatever you might need to use in order to specify which record/s from the spreadsheet to produce the merge output for?



Thanks for the responses. MailMerge sounds like the best and the easiest. That is what I will use.

Blinker920
  • 0



Old topic!
Guest, the last post of this topic is over 365 days. Only Star PT contributors are allowed to post to posts this old.