Sabtu, 17 Desember 2011

[ExcelVBA] Writing No. of chacters of word doc to specific cell

 

Hi

How can I write the file name, no. of characters with spaces and words from an active word doc to specific spreadsheet cells.

I have an index value at C155(=146) and want to write the values to cells O155, Y155 and Z155.

The index value (146) depends on a job number and I can read it from another cell (C6). The value of C6 must be added with 1 to add new values to the next blank line.

Many thanks,

Laerte

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar