PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?TmV3YXJrR29zcw==?=
Guest
Posts: n/a
 
      6th Jul 2007
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.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?c3RldmVfZG9j?=
Guest
Posts: n/a
 
      6th Jul 2007
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.

 
Reply With Quote
 
=?Utf-8?B?TmV3YXJrR29zcw==?=
Guest
Posts: n/a
 
      6th Jul 2007
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:07 AM.