Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
start Word and Mail Merge the data from excel,system will restart tmssupport Excel Discussion (Misc queries) 2 December 18th 07 03:15 PM
"System" Process eating CPU in Excel 2003 Rotd Excel Discussion (Misc queries) 2 December 1st 06 06:55 PM
looking for best system to process intensive excel spreadsheets Qewe Setting up and Configuration of Excel 1 August 7th 06 08:18 PM
EXCEL 2003 - system.diagnostics Christian Lehmann Excel Programming 1 June 1st 06 09:46 PM
running windows system commands in VBA tomek Excel Programming 1 February 5th 04 12:36 PM


All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"