Thread: Need sample for reading value from and writing value to cell E53 from outside Excel
View Single Post
  #6   Report Post  
Posted to microsoft.public.scripting.vbscript,microsoft.public.dotnet.languages.vb,microsoft.public.excel.misc,microsoft.public.excel.programming
Bishop Bishop is offline
external usenet poster
  
Posts: 208
Default Need sample for reading value from and writing value to cell E53 f
"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


here you can find more VBScript Samples to work with Excel
http://www.scriptbox.at.tt/index.php...h=excel&site=1



Reply With QuoteReply With Quote