+ Reply to Thread
Results 1 to 2 of 2

Macro to transfer information to Word or Publisher

  1. #1
    Registered User
    Join Date
    01-08-2015
    Location
    Savannah, GA
    MS-Off Ver
    Office 2013
    Posts
    5

    Macro to transfer information to Word or Publisher

    I'm not very keen on lingo here so I'll try my best to explain what I'm attempting to do. I'm attempting to take a bunch of cells, written as text in excel and turn it into a Word or Publishing document. Multiple people will edit information into the excel and once all information is complete, it is to be transferred.

    You can think of this as a Memo or Newsletter. I have tried to play with formatting in excel, including merging of cells but there are too many intricate spacing to think about prior to adding all the text/data for it to be functional just to convert.

    Ideally what im looking for is a way to reference particular cells and place them in particular parts or format of the word/newletters. I'm starting from the assumption that there will be a template with predefined text boxes, spaces, etc in the document and upon macro command, these would get filled in and formatted according to their current settings.

    Is this a possibility?

    Are there any good online resources to get more information about this type of process? (Again not sure what im looking for as im not on the up and up with the language)

    Is there a better program to complete this function in utilizing macros?

    Thanks

  2. #2
    Registered User
    Join Date
    01-08-2015
    Location
    Savannah, GA
    MS-Off Ver
    Office 2013
    Posts
    5

    Re: Macro to transfer information to Word or Publisher

    Let me be clear I understand there is a pinned thread with resources above, however I'm not sure what verbiage or language im looking for or if this is even a possibility. Any point in the right direction would be extremely helpful, I certainly can figure out how to do it if its doable, I just need ot know where to start, if theres some targeted resource to my issue/question

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is it possilble to transfer data from Excel to Publisher?
    By markhuges in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 10-24-2011, 06:40 AM
  2. Replies: 2
    Last Post: 02-16-2010, 03:53 PM
  3. Using a macro how do I transfer information from excel to word.
    By pandacordova in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-30-2005, 03:45 PM
  4. how do I transfer information from excel to an existing word document using a macro
    By sweetiez1114 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2005, 09:06 AM
  5. [SOLVED] Linking excel with word / publisher
    By rufus870415 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1