Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to 'switch' off warnings in excel during automation?

Status
Not open for further replies.
Nifrabar

Nifrabar

Programmer
Mar 16, 2003
1,343
NL
Hi!
I am creating a piece of automation code to update an excel-sheet.
Part of the automation-job is merging cells.

Than there is the warning:
"The selection contains multiple data values. Merging into one cell will keep the upper-left most data only."

Can I switch that warning off as it is disturbing (stopping) my automation job.
TIA
-Bart
 
Sort by date Sort by votes
found the solution:
oExcel.DisplayAlerts = .F.

-Bart
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ravicoder
  • Locked
  • Question
excel automation printing to pdf error
Replies
8
Views
536
combo
combo
ravicoder
  • Locked
  • Question
Generating graphs using excel automation
Replies
1
Views
211
TamarGranor
TamarGranor
igorsandler
  • Locked
  • Question
Excel automation in FoxPro 7
Replies
1
Views
266
TamarGranor
TamarGranor
ravicoder
  • Locked
  • Question
Adding a worksheet after existing worksheet in excel automation
Replies
5
Views
389
Chris Miller
Chris Miller
ravicoder
  • Locked
  • Question
Using the Union Method of excel automation
Replies
3
Views
257
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top