ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need sample for reading value from and writing value to cell E53 from outside Excel (https://www.excelbanter.com/excel-discussion-misc-queries/191414-need-sample-reading-value-writing-value-cell-e53-outside-excel.html)

Tony Bansten

Need sample for reading value from and writing value to cell E53 from outside Excel
 
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


Bishop

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





All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com