Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
start Word and Mail Merge the data from excel,system will restart | Excel Discussion (Misc queries) | |||
"System" Process eating CPU in Excel 2003 | Excel Discussion (Misc queries) | |||
looking for best system to process intensive excel spreadsheets | Setting up and Configuration of Excel | |||
EXCEL 2003 - system.diagnostics | Excel Programming | |||
running windows system commands in VBA | Excel Programming |