Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.scripting.vbscript,microsoft.public.dotnet.languages.vb,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.scripting.vbscript,microsoft.public.dotnet.languages.vb,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reading a blank cell as zero | Excel Discussion (Misc queries) | |||
Reading a cell in VBA | New Users to Excel | |||
Reading last cell | Excel Discussion (Misc queries) | |||
Reading Cell Function??? | Excel Worksheet Functions | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) |