Discussion:
Open excel without knowing where it is installed
Jason Fischer
2002-07-31 13:28:52 UTC
Permalink
Hi all.

What is the quickest and easiest way of opening Excel from D6 without
knowing where excel is installed.
Likavcsan Ferenc
2002-07-31 13:48:33 UTC
Permalink
Hi!

Probe this:

ShellExecute(0,'open','excel',0,0,SW_SHOWNORMAL);


Fec
-----Original Message-----
From: Jason Fischer [mailto:***@saco.co.za]
Sent: Wednesday, July 31, 2002 3:29 PM
To: Delphi Programing (E-mail)
Subject: [Delphi] Open excel without knowing where it is installed

Hi all.

What is the quickest and easiest way of opening Excel from D6 without
knowing where excel is installed.



The Delphi Top 100!
http://www.sandbrooksoftware.com/TS/TS2/delphi.shtml
---------------------------------------------------------------
Unsubscribe:delphi-programming-***@yahoogroups.com
List owner:delphi-programming-***@yahoogroups.com
---------------------------------------------------------------

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Jason Fischer
2002-07-31 14:14:05 UTC
Permalink
Thanks

That's what I ended up doing

-----Original Message-----
From: Likavcsan Ferenc [mailto:***@chello.hu]
Sent: 31 July 2002 15:49
To: delphi-***@yahoogroups.com
Subject: RE: [Delphi] Open excel without knowing where it is installed


Hi!

Probe this:

ShellExecute(0,'open','excel',0,0,SW_SHOWNORMAL);


Fec
-----Original Message-----
From: Jason Fischer [mailto:***@saco.co.za]
Sent: Wednesday, July 31, 2002 3:29 PM
To: Delphi Programing (E-mail)
Subject: [Delphi] Open excel without knowing where it is installed

Hi all.

What is the quickest and easiest way of opening Excel from D6 without
knowing where excel is installed.



The Delphi Top 100!
http://www.sandbrooksoftware.com/TS/TS2/delphi.shtml
---------------------------------------------------------------
Unsubscribe:delphi-programming-***@yahoogroups.com
List owner:delphi-programming-***@yahoogroups.com
---------------------------------------------------------------

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/




The Delphi Top 100!
http://www.sandbrooksoftware.com/TS/TS2/delphi.shtml
---------------------------------------------------------------
Unsubscribe:delphi-programming-***@yahoogroups.com
List owner:delphi-programming-***@yahoogroups.com
---------------------------------------------------------------

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Mark Warriner
2002-07-31 13:51:02 UTC
Permalink
I'm not sure from your mail if you want to open excel with a blank worksheet
or open a file.
If you want to open a file using Excel from D6, then you can use the
ShellExecute api:

procedure TForm1.OpenFile(const S: String);
begin
ShellExecute(Handle, 'open', PChar(S), nil, nil, SW_SHOW);
end;

This will open the program associated with the extension of the file you
want to open.
If S is an *.xls file, it will open with excel.




-----Original Message-----
From: Jason Fischer [mailto:***@saco.co.za]
Sent: 31 July 2002 14:29
To: Delphi Programing (E-mail)
Subject: [Delphi] Open excel without knowing where it is installed


Hi all.

What is the quickest and easiest way of opening Excel from D6 without
knowing where excel is installed.



The Delphi Top 100!
http://www.sandbrooksoftware.com/TS/TS2/delphi.shtml
---------------------------------------------------------------
Unsubscribe:delphi-programming-***@yahoogroups.com
List owner:delphi-programming-***@yahoogroups.com
---------------------------------------------------------------

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Eduardo Duran
2002-07-31 20:45:29 UTC
Permalink
ShellExecute? Wich Unit?... in help says
Import library Shell32.lib but don´t find it.
I´m Using D6 & Win2000 Server

----- Original Message -----
From: "Mark Warriner" <***@nxtsound.com>
To: <delphi-***@yahoogroups.com>
Sent: Wednesday, July 31, 2002 6:51 AM
Subject: RE: [Delphi] Open excel without knowing where it is installed
Post by Mark Warriner
I'm not sure from your mail if you want to open excel with a blank worksheet
or open a file.
If you want to open a file using Excel from D6, then you can use the
procedure TForm1.OpenFile(const S: String);
begin
ShellExecute(Handle, 'open', PChar(S), nil, nil, SW_SHOW);
end;
This will open the program associated with the extension of the file you
want to open.
If S is an *.xls file, it will open with excel.
-----Original Message-----
Sent: 31 July 2002 14:29
To: Delphi Programing (E-mail)
Subject: [Delphi] Open excel without knowing where it is installed
Hi all.
What is the quickest and easiest way of opening Excel from D6 without
knowing where excel is installed.
The Delphi Top 100!
http://www.sandbrooksoftware.com/TS/TS2/delphi.shtml
---------------------------------------------------------------
---------------------------------------------------------------
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
The Delphi Top 100!
http://www.sandbrooksoftware.com/TS/TS2/delphi.shtml
---------------------------------------------------------------
---------------------------------------------------------------
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Stephen Wood
2002-07-31 19:39:30 UTC
Permalink
Use ShellAPI...

----- Original Message -----
From: "Eduardo Duran" <***@aegsa.com>
To: <delphi-***@yahoogroups.com>
Sent: Wednesday, July 31, 2002 10:45 PM
Subject: Re: [Delphi] Open excel without knowing where it is installed
Post by Eduardo Duran
ShellExecute? Wich Unit?... in help says
Import library Shell32.lib but don´t find it.
I´m Using D6 & Win2000 Server
----- Original Message -----
Sent: Wednesday, July 31, 2002 6:51 AM
Subject: RE: [Delphi] Open excel without knowing where it is installed
Post by Mark Warriner
I'm not sure from your mail if you want to open excel with a blank
worksheet
Post by Mark Warriner
or open a file.
If you want to open a file using Excel from D6, then you can use the
procedure TForm1.OpenFile(const S: String);
begin
ShellExecute(Handle, 'open', PChar(S), nil, nil, SW_SHOW);
end;
This will open the program associated with the extension of the file you
want to open.
If S is an *.xls file, it will open with excel.
-----Original Message-----
Sent: 31 July 2002 14:29
To: Delphi Programing (E-mail)
Subject: [Delphi] Open excel without knowing where it is installed
Hi all.
What is the quickest and easiest way of opening Excel from D6 without
knowing where excel is installed.
The Delphi Top 100!
http://www.sandbrooksoftware.com/TS/TS2/delphi.shtml
---------------------------------------------------------------
---------------------------------------------------------------
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Post by Eduardo Duran
Post by Mark Warriner
The Delphi Top 100!
http://www.sandbrooksoftware.com/TS/TS2/delphi.shtml
---------------------------------------------------------------
---------------------------------------------------------------
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Post by Eduardo Duran
The Delphi Top 100!
http://www.sandbrooksoftware.com/TS/TS2/delphi.shtml
---------------------------------------------------------------
---------------------------------------------------------------
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Rajendra V. Patade
2002-08-01 09:36:53 UTC
Permalink
Hi
i have a problem here
see if u can help me
My application will be supplied with a file which is not atemplate excel
file but a normal data file
i need to find out the format used in the file and save it in the db for
making the use of the tamplate for theperticular type of out put file
now actually wht i am doing is i get the position of the last cell usd in
the file by xlLastCell passed to the specialcell method
but i need to loop from the first till the last cell used in the file and
store the format properties of each file in the db
can some body suggest me how can i achieve this
thanks
Rajendra...


APIwithDelphi · API with Delphi
http://groups.yahoo.com/group/APIwithDelphi/
---------------------------------------------------------------
Unsubscribe:delphi-programming-***@yahoogroups.com
List owner:delphi-programming-***@yahoogroups.com
---------------------------------------------------------------

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Glenn B. Lawler
2002-07-31 15:53:11 UTC
Permalink
Check API Help for: FindExecutable

This returns the program associated with a file extension.

- Glenn Lawler
Post by Jason Fischer
Hi all.
What is the quickest and easiest way of opening Excel from D6 without
knowing where excel is installed.
Continue reading on narkive:
Loading...