View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] boris.toll@gmail.com is offline
external usenet poster
 
Posts: 1
Default Need sample for reading value from and writing value to cell E53from outside Excel

On 16 Jun., 20:48, (Tony Bansten) wrote:
As fas as I heard I can write to Excel cell e.g. E53 from outside with VBS.

How could such a code look like?

Assume I have an Excel file aaa.xls and a worksheet "ws777" inside:
How can I wread and write to this cell?

Tony


Here is a sample VBScript to write to a specific Excel Worksheet:
http://www.scriptbox.at.tt/index.php?search=Open an Excel Workbook and
write a Value to a specific Worksheet.vbs&site=1


You can find more Excel VBS Samples he
http://www.scriptbox.at.tt/index.php...h=Excel&site=1