System.Diagnostics.Process.Start Excel Commands

A

AceWonder

Im looking for a list of commands to execute in run.

Example:
System.Diagnostics.Process.Start("mailto:[email protected]&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.
 
J

Joel

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.
 
A

AceWonder

Heres an example of what I thought what I needed would look lik
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top