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
__._,_.___
----------------------------------
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
----------------------------------
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
.
__,_._,___
Tidak ada komentar:
Posting Komentar