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
Bookmarks