How can I turn off the OLE warning when merging cells?

's Computer Specifications

I am doing OLE from VFP9. When I try to merge a range of cells, Excel puts
up a warning dialog. How do I suppress this.

's Computer Specifications

Have you tried Application.Display alerts = False ?

"NewarkGoss" wrote:

> I am doing OLE from VFP9. When I try to merge a range of cells, Excel puts
> up a warning dialog. How do I suppress this.

's Computer Specifications

Thanks Steve. That worked as <oleobject>.DisplayAlerts = False (no space)

"steve_doc" wrote:

> Have you tried Application.Display alerts = False ?
>
> "NewarkGoss" wrote:
>
> > I am doing OLE from VFP9. When I try to merge a range of cells, Excel puts
> > up a warning dialog. How do I suppress this.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
merging cells and eliminating spaces for empty cells	Jill	Microsoft Excel Misc	2	2nd Apr 2010 07:43 PM
how do I turn on Layout Tables and Cells task pane to turn on ?	=?Utf-8?B?aGVscCBzb21lb25l?=	Microsoft Frontpage	3	5th Oct 2004 10:25 AM
Problem with Merging Data Cells with Empty Cells	Te_Diddy	Microsoft Excel Misc	3	9th Aug 2004 10:33 AM
Suppress warning when Merging Cells by Code	Ashish	Microsoft Excel Discussion	2	16th Apr 2004 06:09 AM
Merging Cells and Merging Data	=?Utf-8?B?SmZlcmd5?=	Microsoft Excel Misc	2	12th Mar 2004 06:13 PM