+ Reply to Thread
Results 1 to 2 of 2

Excel Macro for differnt font & add hyperlink to part of text in single table cell in word

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    kolkata
    MS-Off Ver
    Excel 2010
    Posts
    1

    Excel Macro for differnt font & add hyperlink to part of text in single table cell in word

    I really got stuck with some problem when I am creating word document (with particular format) through excel macro. I have a button in excel. fter clicking on it a word document will open. In word document text and multiple table will be there. Number of row and column are different in different. I had able to create the same. Now the problem is I have to make different font size and color in same cell for different part of text in the cell. Also I have to create hyperlink in part of text in a cell (not whole cell contain) which will connect to a lotus notes database. For example I am sending a cell contain of my requirement (different line's Values will come from different cell of excel)

    ==========================================================

    INVESTMENTS: PAM US Pervasive to Oracle <link>
    New SDLC Process: Yes

    Impl Date: May 5, 2012 Budget: $101,000 (L1)

    % Budget Spent: 16% % Duration Complete: 15%

    Prj Sponsors: Exec: Jeff Spann, Proj: Maria Springer

    IT Delivery: AM: Tony Perry PM: Dale Smith

    Detailed Status: Link

    ======================================

    Can anyone please help me to come out with some solution, how to do the same? Also please advise if there is any resource available who can help us if we face any issue to develop our current project? If anyone have any supporting document please send.

    Thanks in advance. Sukanta

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel Macro for differnt font & add hyperlink to part of text in single table cell in

    In Excel you cannot put a link on "part" of the text in a single cell. The Hyperlink functions allow you to add a hyperlink by CTRL-K or by the formula =HYPERLINK(), but the results are the same either way, then entire cell will have the one hyperlink.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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