TechRepublic : A ZDNet Tech Community

DOWNLOAD: Export Excel comments to Word

Tags: download, scripting, vbscript, microsoft word, microsoft excel, off-topic
Report as spam Discussion  -  Post 1 of 4
DOWNLOAD: Export Excel comments to Word
Excel's comment feature allows you to quickly and easily describe a cell's function or provide additional information. While printing these comments is relatively simple, getting them into a Word document can prove more difficult. You can manually copy and paste each comment, but this is tedious and time-consuming.

The Export Excel comments to Word VBScript makes the job a snap. This handy script copies the cell comments from an Excel workbook to a new Word <ocument. The script works on Excel workbooks with multiple worksheets and exports each comment's cell reference and text.

Download and try the VBScript:
http://techrepublic.com.com/5138-10877-5749447.html

Then, join this ongoing discussion and let us know if you find the Delete Word Document Hyperlinks VBScript useful and if there's anything we can do to improve the tool.
Posted: 06/16/2005 @ 07:17 AM (PDT)
avatar
Bill Detwiler - TechRepublic     1
Job Role: Other
Location: LOUISVILLE, Kentucky
Member since: 07/12/2000

View Profile  | Send Message
Post a Reply Save
« Previous  |  Next »

Print/View all Posts | Subscribe to this Thread 

DOWNLOAD: Export Excel comments to WordBill Detwiler - TechRepublic | 06/16/2005 @ 07:17 AM (PDT)
Enhancement for hidden cellsmweir2@... | 02/27/2008 @ 03:59 PM (PST)
Adding a Browse buttonwade_issa@... | 08/01/2008 @ 08:36 AM (PDT)
didn't workmmschneider@... | 01/21/2009 @ 08:51 AM (PST)

SponsoredWhite Papers, Webcasts, and Downloads

White Papers, Webcasts, and Downloads

Browse by Tag

networking
Popular tags: windows,  software,  hardware,  security,  it management
e-mail
Popular tags: windows,  software,  networking,  security,  hardware
hardware
Popular tags: windows,  software,  networking,  it management,  security
programming
Popular tags: software,  windows,  networking,  hardware,  it management
software
Popular tags: windows,  hardware,  networking,  programming,  it management
windows
Popular tags: software,  networking,  hardware,  security,  it management
linux
Popular tags: software,  windows,  networking,  hardware,  security
it management
Popular tags: networking,  windows,  software,  security,  hardware
career
Popular tags: it management,  networking,  software,  windows,  feedback
security
Popular tags: networking,  windows,  software,  it management,  hardware
off-topic
Popular tags: software,  windows,  hardware,  feedback,  networking
feedback
Popular tags: software,  windows,  hardware,  networking,  it management
project management
Popular tags: it management,  software,  networking,  windows,  programming
500 Things Every Technology Professional Needs to Know
Did you know Microsoft's RegClean does not work with XP but you can use shareware to clean your registry? Did you know most wireless access points don't have encryption enabled by default? Did you know there are 500 tidbits of information contained in TechRepublic's 500 Things Every Technology Professional Needs to Know that will help you become a successful IT professional.
Buy Now
Administrator's Guide to TCP/IP, Second Edition
Maintain your critical TCP/IP system and ensure reliable, safe remote access. Get the expert advice and solutions to handle Windows networking, Cisco routing, documentation, and troubleshooting.
Buy Now

SmartPlanet

Click Here