MS EXCEL - To supress warning messages created by Anlysis ToolPak
 

Hi,

I have been creating a MS ACESS Application, whose final output will be an
excel sheet having a histogram in it ( created using analysis toolPak add ins
)

I have suppressed all the warning messages created by excel using
Application.DisplayAlerts = False

But I am unable to suppress the messages created by analysis toolPak Add
INS macro for €œHistogram€�

Do you have any solution for this? It will be of great help.

Application.DisplayAlerts = False
Application.Run
"ATPVBAEN.XLA!Histogram"ActiveSheet.Range("$B$3:$B $10002") _
, ActiveSheet.Range("$E$3:$F$104"), , False, False, True, False
Application.DisplayAlerts = True

The messages that I got were

1) Histogram €“ Output range will overwrite the existing data. Press OK to
overwrite data in range
&
2) Histogram €“ some data will be hidden by embedded chart(s)

Thanks & Regards,
Niyaz .R

MS EXCEL - To supress warning messages created by Anlysis ToolPak
 

Clear the range ActiveSheet.Range("$E$3:$F$104")
before executing the Application.Run command.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Niyaz Rasheed" <Niyaz wrote in message
...
Hi,

I have been creating a MS ACESS Application, whose final output will be an
excel sheet having a histogram in it ( created using analysis toolPak add
ins
)

I have suppressed all the warning messages created by excel using
Application.DisplayAlerts = False

But I am unable to suppress the messages created by analysis toolPak
Add
INS macro for €œHistogram€�

Do you have any solution for this? It will be of great help.

Application.DisplayAlerts = False
Application.Run
"ATPVBAEN.XLA!Histogram"ActiveSheet.Range("$B$3:$B $10002") _
, ActiveSheet.Range("$E$3:$F$104"), , False, False, True, False
Application.DisplayAlerts = True

The messages that I got were

1) Histogram €“ Output range will overwrite the existing data. Press OK to
overwrite data in range
&
2) Histogram €“ some data will be hidden by embedded chart(s)

Thanks & Regards,
Niyaz .R