RE: Automate Microsoft Office from Delphi

2013-01-25 Thread Jerry Clancy
François,

Your blog page says this is not found.

Jerry

-Original Message-
From: delphi-boun...@elists.org [mailto:delphi-boun...@elists.org] On Behalf Of 
François Piette
Sent: Wednesday, January 23, 2013 11:49 AM
To: Moderated List for the Discussion of Delphi Programming excluding 
Database-related topics
Subject: Automate Microsoft Office from Delphi

Microsoft Office (Word, Excel and others) are applications which can be fully 
automated from another application. Everything you can do by hand can also be 
done programmatically from another application and of course from your Delphi 
application.

To ease the automation, Delphi is delivered with non-visual components which 
are wrapper around the underlying COM objects and exposes the same 
properties, methods and events as the COM interface.

 

Read the full article at:

http://francois-piette.blogspot.be/2013/01/automate-microsoft-office-from-de
lphi.html

 

--

François Piette

 

___
Delphi mailing list
Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi
___
Delphi mailing list
Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: Determine line number from MAP file

2010-08-08 Thread Jerry Clancy
After almost 50 years of doing this, I have always disagreed with bottom 
posting and I think the arguments for it are bogus. The subject determines 
whether or not you are interested in the thread and, if you are, you've likely 
read all the prior posts and in each new one you are only interested in the 
pertinent part, i.e., the new information. I have no interest in wading through 
the prior four or five posts to get the answer. In fact, I find it annoying 
that I have to go find it, particularly if it's below the visible message 
window. So much for the natural order. The mind handles this inversion with 
ease.

The only time bottom posting is necessary is when the prior post raises several 
subjects, in which case interspersion of the answers makes more sense.

We are better served by having the poster cut all but the relevant part of the 
previous post and giving us the response right at the top, which is where the 
readers put you.

The prior post, below, actually responded to two messages and puts the one not 
relevant to the subject at the very bottom after the signature, raising 
questions in the mind of the reader about whether it's a previous post or part 
of the same one. It's also cute by reversing the messages all together to make 
the writer's point. However, these messages would not naturally have occurred 
together but instead would have occurred as four posts and the need for order 
would have disappeared. The reader would not have been confused by top-posting.

FWIW,

Jerry

-Original Message-
From: delphi-boun...@elists.org [mailto:delphi-boun...@elists.org] On Behalf Of 
Doug Chamberlin
Sent: Friday, August 06, 2010 9:07 AM
To: delphi@elists.org
Subject: Re: Determine line number from MAP file

  This also might be helpful:
http://www.drbob42.com/delphi/findmap.htm

-- 
Cheers! Doug C.
--
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?

___
Delphi mailing list
Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi
___
Delphi mailing list
Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


Panic: Delphi 5 Ent. freezing at splash screen

2010-01-13 Thread Jerry Clancy
Help! Earlier this evening I was debugging a project and all was going just 
fine. Then in debug mode D5 itself crashed (a common one) and I noticed that I 
had two copies of delphi32.exe running in Task Manager. Since D5 wouldn't close 
I ended both programs using TMgr. I then decided to restart Delphi by clicking 
the project file and D2009 started by mistake (I have both on the system). I 
closed it after it fully opened. However, on reopening D5 it now freezes a 
few seconds after displaying the D5 splash screen. I notice eventually that a 
2nd Delphi 5 entry appears in Task Manager and the CPU usage is at 100% until I 
kill them.

I am now suspecting a Registry issue. The only Borland D5 file that seems to 
have changed is delphi32.dmt in the Bin folder.

This actually could not have happened at a worst time, as I have deliverables 
due tomorrow. Any thoughts on how to proceed short of reinstalling D5 would be 
most welcome.

Never had this happen in 15 years of using Delphi.

Jerry

___
Delphi mailing list
Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: Panic: Delphi 5 Ent. freezing at splash screen - SOLVED

2010-01-13 Thread Jerry Clancy
Problem solved.  I started D5 by clicking another project and it opened OK. The 
inadvertent opening of the original project with D2009 corrupted the D5 project 
files. Once these D2009 project files were deleted the D5 project then opened 
without incident.

Jerry

___
Delphi mailing list
Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: [Delphi] Rave 8 FINALLY Released, Claims to Support Delphi 2010

2010-01-10 Thread Jerry Clancy
Very good to hear.

Jerry

-Original Message-
From: delphi-boun...@elists.org [mailto:delphi-boun...@elists.org] On Behalf Of 
Glenn Crouch
Sent: Sunday, January 10, 2010 12:54 AM
To: 'Moderated List for the Discussion of Delphi Programming excluding 
Database-related topics'
Subject: RE: [Delphi] Rave 8 FINALLY Released, Claims to Support Delphi 2010

 So it looks like upgrading to D2010 is indeed feasible for me.

I'm using Delphi 2010 with the just release Rave 8 - all appears well :)


Glenn Crouch, mailto:gl...@esbconsult.com
ESB Consultancy, http://www.esbconsult.com
Follow us on Twitter: http://twitter.com/esbglenn 
Home of ESBPCS, ESB Calculators, ESBStats and ESBPDF Analysis
Kalgoorlie-Boulder, Western Australia 
___
Delphi mailing list
Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: code based reporting with Rave

2009-05-07 Thread Jerry Clancy
Alan,

Nevrona has a TRTFFiler component but it's too basic for our needs and you may 
find it so for yours. Instead, I've been generating for years my own raw RTF 
code to a TTextFiler component (using PrintData). We save the file with an .rtf 
extension and then typically send it back with a NewWindow function.

Here's today's Congressional Report generated to RTF:
http://www.billtrak.net/us111/docs/csdr090505.rtf

There's a minor bug regarding the doubling of the bill numbers but this will 
give you the idea.

Jerry

-Original Message-
From: delphi-boun...@elists.org [mailto:delphi-boun...@elists.org] On Behalf Of 
Alan Colburn
Sent: Wednesday, May 06, 2009 11:51 AM
To: Borland's Delphi Discussion List
Subject: Re: code based reporting with Rave

I think I may have been misunderstood ... I'm talking about creating a
report (in code) and then exporting it to RTF. The resulting RTF file has
every word in its own textbox.
|

___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi
___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: code based reporting with Rave

2009-05-06 Thread Jerry Clancy
Although editing a pdf document is theorectically possible (I have done some 
tentative link editing in the past), it's a bit like editing rtf docs -- miss a 
squiggle and you're dead (I do generate my own rtf code). Acrobat allows you 
limited editing, such as adding and deleting pages, glueing pdfs together, 
etc., but I would recommend to sticking with editing the base document in its 
native form.

Jerry

-Original Message-
From: delphi-boun...@elists.org [mailto:delphi-boun...@elists.org] On Behalf Of 
Alan Colburn
Sent: Tuesday, May 05, 2009 3:20 PM
To: Borland's Delphi Discussion List
Subject: Re: code based reporting with Rave

I do everything with code, too (thanks, in part, to Jerry's help :-) ... I'm
curious about saving reports in RTF format. I find the resulting document to
be virtually uneditable. It seems like every word is formatted into its own
text box. Is that the norm?

Thanks -- Al C.
___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: Updating components and libraries for use under D2009

2009-05-03 Thread Jerry Clancy
Most of their products went open source (SourceForge), so there may be later 
versions. I just stopped using them.

Jerry

-Original Message-
From: delphi-boun...@elists.org [mailto:delphi-boun...@elists.org] On Behalf Of 
Robert Meek
Sent: Saturday, May 02, 2009 11:20 AM
To: delphi@elists.org
Subject: Updating components and libraries for use under D2009

Hi all,
I was wondering if anyone had attempted and possibly succeeded in
updating SysTools and/or Lockbox from TurboPower for use under D2009.  I had
no trouble doing so for 2007 of course, but now I'm getting tons of string
errors when I try to compile them as I figured I would.
Most of the errors seem to be incompatible types AnsiChar to Char.
In such cases do you think it would be okay simply to change the types in
the source code, or is there a better, easier way of handling this problem?
The rest are all warnings of implicit stringcast from AnsiString to
String or ShortString to String, mixed in with a few of the same but with
probable loss of data.

from Robert Meek dba Tangentals Design
Creative Concepts Programming for Windows Vista
E-mail:  ffo...@comcast.net
Most people would sooner die than think; in fact, they do so!
[Bertrand Russell  1872-1970]


___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi
___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: code based reporting with Rave

2009-05-03 Thread Jerry Clancy
Wilfried,

Use D5, not Delphi7, but have been using code-based Rave since its inception to 
produce reports such as this:
  http://www.billtrak.net/us111/csdrs/csdr090430.pdf

Don't do graphics, etc., but if you have questions regarding how to use the 
product feel free to post questions. They also have a public support group at
  nevrona.public.rave.developer.delphi.code-based

Jerry


-Original Message-
From: delphi-boun...@elists.org [mailto:delphi-boun...@elists.org] On Behalf Of 
Wilfried Mestdagh
Sent: Sunday, May 03, 2009 6:45 AM
To: delphi@elists.org
Subject: code based reporting with Rave

Hello,

I found this article which describes code based reporting with Rave:
http://edn.embarcadero.com/article/30329

But the code is incomplete and the link to the source is dead. Does
someone has another link, or this source, or other similar example using
Delphi7?

Thx, Wilfried
___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: Wrong application icon

2008-12-09 Thread Jerry Clancy
Go to Project | Options | Application and change the loaded icon.

Jerry

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of CubicDesign
Sent: Monday, December 08, 2008 7:39 PM
To: Borland's Delphi Discussion List
Subject: Wrong application icon

Hi. The Application Icon of my application is wrong.

My application shows in taskbar a different icon than the classic Delphi
icon. Instead is shows the icon of one of my VCL's. That specific VCL
from which the icon was stolen is not used in my application but other
VCL's in the same package are used.

Related info: - The icon looks ok if I drag and drop my app on Desktop.
- The icon looks ok in Windows Commander when I put the cursor on it. -
The icon does not look ok in Windows Commander when I drag and drop it
in Button Bar. Conclusion: the icon is not accidentally changed at the
runtime (the problem is there even if the application is not running).

I use Delphi 7.
I have not even the slightest clue why the compiler inserts the wrong
icon. I really need some hints. Thanks.

D.

___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi
___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: Help - Iv'e screwed up Delphi 2007

2008-10-31 Thread Jerry Clancy
John,

I can empathize with your frustration. With any luck Component | Install 
Packages will have the missing packages listed but unchecked and with the full 
path of the package listed below. If so, try to add them back in. Also check 
your library paths which at this point may also be screwed up or ill-ordered or 
have a mixture of both versions. I've been there before. It's a bit of trial 
and error trying to reload the IDE.

Only thoughts I have at the moment.

Jerry

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Barrat
Sent: Thursday, October 30, 2008 5:01 AM
To: 'Borland's Delphi Discussion List'
Subject: Help - Iv'e screwed up Delphi 2007

Stupidly I attempted to run what I thought was a previous version of Delphi
2006 on my machine installed with my working version of Delphi 2007.

As the application came up it kept on reporting that it could not find
certain packages and asked if it should attempt to re-load them next time.
Now this is where I went wrong - to many of the popups I choose No.
Needless to say Delphi 2006 didn't work, but to my surprise when I tried to
run my current version od Delphi 2007 it loaded much more quickly -
obviously skipping all the packages it should have been installing.  Now I
cannot do anything with it.  If I try and open anything up in the IDE or
attempt to start a new project I get a memory access violation.

I have tried repairing Delphi and re-installing from my original disk and
then running updates but to no avail.

Can someone advise me on how I can recover the situation?

John Barrat
___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi
___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: Help w/Registered File Types

2008-05-19 Thread Jerry Clancy
Haven't done this in many years and have no clue where the old code is, but 
what you want to look at are Delphi OLE Automation Servers. Here's a starting 
point:
http://delphi.about.com/od/kbcontrolole/ss/word_automation.htm
I believe it is addressed in serveral of the old standard Delphi books, 
(Calvert, etc.), so you might want to start there for whole coding examples.

Jerry

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Meek
Sent: Monday, May 19, 2008 6:11 AM
To: delphi@elists.org
Subject: Help w/Registered File Types

Morning all,
I have an urgent need that I hope someone here can help me figure
out how to handle, involving how to find out the full path and filename of
an application via it being the registered file type for a selected data
file!
In my application, the user selects a data file, for example a .doc
file which on most systems will be registered to open with Microsoft Word.
How can my application find out if it has a registered application, what its
registered application is, and return the path and filename of it to the
user without actually launching the data file?
Thanx in advance for any help!

from Robert Meek dba Tangentals Design
e-mail: [EMAIL PROTECTED]
___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: Delphi IDE Debug limit

2008-04-13 Thread Jerry Clancy
Are you running the D5 IDE under XP or Vista?

Jerry

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darling, Michael
Sent: Friday, April 11, 2008 12:16 PM
To: Borland's Delphi Discussion List
Subject: Delphi IDE Debug limit

Is there a known size limit to Form/Pas files in Delphi, specifically
Delphi 5?
...
___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


RE: IDE Pallette

2008-04-03 Thread Jerry Clancy
D5 and, thanks to those who mentioned Gexperts (which is installed), I found 
the IDE configuration menu with the multiline checkbox. Had to enable changes 
to the IDE first, but I now have my multiline pallette.

Thanks to all who responded.

Jerry

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Francois Piette
Sent: Thursday, April 03, 2008 2:30 AM
To: Borland's Delphi Discussion List
Subject: Re: IDE Pallette

 There's an old trick that I have forgotten than makes the component
 pallette in the IDE multi-line. Does anyone else remember it?
 Moved my development system and now I have one line with a
 zillion component packages on it.

Which Delphi version are you using ?

___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


Re: Moving D5 seems like Groundhog Day repeating itself

2008-03-06 Thread Jerry Clancy
Thanks to all of you guys that responded.

Have it all working now. The problem was mostly the list of the library paths, 
which I had simply forgotten about. This solved 90% of the problems. I had also 
forgotten to transfer one system32 .bpl file. Reinstalling Indy and one other 
package solved the other two problems. I even remembered to change all the .dsk 
files.

Overall, sneaking the packages over sure beats trying to install them over 
again. I think it's faster and safer, actually. Glad it's done.

Jerry


At 07:50 PM 3/5/2008, you wrote:

Did you update the library paths?  That's my usual trick


___
Delphi mailing list - Delphi@elists.org
http://lists.elists.org/cgi-bin/mailman/listinfo/delphi


Re: As EXE grows Delphi (7) gets way slower; what to do?

2007-10-16 Thread Jerry Clancy
Off the top:

* Check your virtual memory settings. They may be too low.
* Defrag your hard disk.
* Look for adware, malware and trojans.
* Turn off autoindexing on drives if ON.
* Remove unnecessary startup programs.
* Delete all DCUs and rebuild the project.

Jerry

At 10:48 AM 10/15/2007, you wrote:

Hello:

As the program that I'm working has been growing, at some point--about 
10-12 mb EXE size--Delphi 7 started becoming VERY much slower. What used 
to be seconds to compile, takes 2 minutes. Whenever I scroll or even add 
a few keystrokes to the editor, Delphi goes into some limbo where the 
disk drive is accessed a lot and I can't continue until it is finished. 
Looks like some kind of auto save or auto compile, but it takes almost 
as long as compiling does.

I'm using a single CPU, 2.5 gHz system.

I've done the following. Anything else I can do?

Increased RAM from 512mb to 1Gb - this cut down compile time by half, 
but still way slower than it was before.

Also, noticed that even small, test projects compile slower.

Noticed my C: drive (used for WindowsXP, SP2, btw) and my D: partition 
for programs and data, was getting low on disk space so I repartitioned 
that from 10-20 gb, which helped only a little, although helped Windows 
noticeably.

Thanks for any tips,

Chuck Belanger


___
Delphi mailing list - Delphi@elists.org
http://www.elists.org/mailman/listinfo/delphi


___
Delphi mailing list - Delphi@elists.org
http://www.elists.org/mailman/listinfo/delphi


Re: RS232 procedures

2007-01-11 Thread Jerry Clancy
Peter,

Go to sourceforge.net. The Turbo Async packages are now open source.

Jerry

At 01:53 AM 1/10/2007, you wrote:

Hi guys,

I'd like to control serial port (com0, com1) from a Delphi program.
I found some examples on the net but they are too complicated
to implement them into my smal program. Please point me
to the simple application for RS232.

Thank you,
Peter


___
Delphi mailing list - Delphi@elists.org
http://www.elists.org/mailman/listinfo/delphi


Re: Some editing and debugging features have disappeared

2006-10-21 Thread Jerry Clancy
Rob,

Did you check the Project | Options | Compiler settings to make sure 
the debugger options are checked? These may be needed to see the vars 
at runtime. Can't remember.

Jerry

At 12:38 PM 10/20/2006, you wrote:

Hi everyone,

My PC froze the other day and I had to hold down the power button and
restart from cold.  I had Delphi open at the time - but I think the
fault was elsewhere - maybe in Firefox.  In any case, ever since then
several useful features seem to have disappeared from the Delphi Editor
and Debugging system, namely:

At design time:
- the name and class of  a VCL object no longer appear when the mouse
hovers over the object on screen;
- the CTRL + click no longer takes me to the declaration of a function,
type or variable unless the declaration is in the same unit (although
the hourglass cursor does appear, which makes me think it is locating
the declarartion but not displaying it).

In debugging and stepping through code:
- the values of variables no longer appear when the mouse hovers over
the variable name on screen

For a day or two I just adapted and found other ways of doing these
things (and I suppose hoping that they would just correct themselves a
fter a few restarts  :-)  )  but I'm getting frustrated now.

I've tried going into the Tools | Editor options | Code insight and
switching things on and off with no success.

Anyone got any ideas on how to get these things back?

Thanks,

Rob

___
Delphi mailing list - Delphi@elists.org
http://www.elists.org/mailman/listinfo/delphi


___
Delphi mailing list - Delphi@elists.org
http://www.elists.org/mailman/listinfo/delphi


Re: Getting an IP Address from a domain name

2006-07-07 Thread Jerry Clancy
Ping the domain. That domain, btw, returns 65.125.108.20 from DNS and 
apparently wasn't online when pinged.

Note that the IP could be different at different times, depending 
upon whether the host is using DHCP or dedicated IPs.

Jerry


At 06:03 PM 7/6/2006, you wrote:

Hi All,

I have a project that I thought would be a snap and it has turned out to be
a pain.  I need to get the Host IP from a domain name, IE -
www.skpontiac.com to 12.163.44.20

Anyone have any tools or suggestion, I would greatly appreciate it.

So far I have tried Indy 9.0 idDNSResolver with no success.

Steve Gaskin


___
Delphi mailing list - Delphi@elists.org
http://www.elists.org/mailman/listinfo/delphi