ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   System.Diagnostics.Process.Start Excel Commands (https://www.excelbanter.com/excel-programming/422165-system-diagnostics-process-start-excel-commands.html)

AceWonder

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.

joel

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.


AceWonder

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