![]() |
System.Diagnostics.Process.Start Excel Commands
Im looking for a list of commands to execute in run.
Example: System.Diagnostics.Process.Start("mailto:me@myemai l.com&subject=Request%20Information&body=Request:% 0A%0A%0A%0A%0A%0A%0ACONFIDENTIALITY NOTICE"); The above line works fine, well I want to do this for excel as well, but I am having trouble finding the commands for a cell in excel. How would a write information to specific cells in excel using the same process? what I tried: System.Diagnostics.Process.Start("EXCEL.EXE"); this works fine, but when I tried to find Cell line commands I was unable to get anything to work. |
System.Diagnostics.Process.Start Excel Commands
What you need to do is to is to have excel open a workbook up with a workbook
open event that saves at text file. then verify the text file generated by excel gives the correct data System.Diagnostics.Process.Start("EXCEL.EXE c:\My Folder\SystemText.Xls"); Then in SystemText.xls insert a workbook Open Event which creates a text file. Then you can compare the text file with a templet using COMP (compares two text files) to verify Excel is operational. The Workbook Open Event can perform a series of different excel commands to verify that excel is working correctly. "AceWonder" wrote: Im looking for a list of commands to execute in run. Example: System.Diagnostics.Process.Start("mailto:me@myemai l.com&subject=Request%20Information&body=Request:% 0A%0A%0A%0A%0A%0A%0ACONFIDENTIALITY NOTICE"); The above line works fine, well I want to do this for excel as well, but I am having trouble finding the commands for a cell in excel. How would a write information to specific cells in excel using the same process? what I tried: System.Diagnostics.Process.Start("EXCEL.EXE"); this works fine, but when I tried to find Cell line commands I was unable to get anything to work. |
System.Diagnostics.Process.Start Excel Commands
Heres an example of what I thought what I needed would look like
System.Diagnostics.Process.Start("EXCEL.EXE:Create =Filename.xls&Range(A1)=Data1&Range(A2)=Data2"); I would just like the simple commands like this... I attempted what you were talking about, but I didn't get any information that I needed that was like this for the Start Run (maybe I did it wrong). I just got a text file with the information spaced out. I can open it up no problem through the program I am using, but what I am doing is generating the data, and it will enter the data to the appropriate ranges when I execute my request form. "Joel" wrote: What you need to do is to is to have excel open a workbook up with a workbook open event that saves at text file. then verify the text file generated by excel gives the correct data System.Diagnostics.Process.Start("EXCEL.EXE c:\My Folder\SystemText.Xls"); Then in SystemText.xls insert a workbook Open Event which creates a text file. Then you can compare the text file with a templet using COMP (compares two text files) to verify Excel is operational. The Workbook Open Event can perform a series of different excel commands to verify that excel is working correctly. "AceWonder" wrote: Im looking for a list of commands to execute in run. Example: System.Diagnostics.Process.Start("mailto:me@myemai l.com&subject=Request%20Information&body=Request:% 0A%0A%0A%0A%0A%0A%0ACONFIDENTIALITY NOTICE"); The above line works fine, well I want to do this for excel as well, but I am having trouble finding the commands for a cell in excel. How would a write information to specific cells in excel using the same process? what I tried: System.Diagnostics.Process.Start("EXCEL.EXE"); this works fine, but when I tried to find Cell line commands I was unable to get anything to work. |
All times are GMT +1. The time now is 03:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com