Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
DisplayAlerts = False not working in VBA

When I open new excel application in VBA code in Microsoft Vista, it will give me "BCM office Addin" warning by Excel 2003 program such as "Office application version does not match" and prompt "confirm" button in the message box.
Each time I need to press the confirm keys in order to run the applcation. How to ignor the warning
automatically by VBA code or send a enter key to do the confirm by VBA code?
I try to use application.DisplayAlerts = False that is also not working, please help and review my following code
Sub openexcel()
Dim ex As New Excel.Application
ex.DisplayAlerts = False
ex.Workbooks.Open(C:myfile).NewWindow
ex.visible
End Sub
Question-2
THe other question is how to set excel application window width and height ?
I try to use
ex.PageSetup.BottomMargin = 10
ex.PageSetup.LeftMargin = 15
ex.PageSetup.RightMargin = 10
ex.PageSetup.TopMargin = 10
but it doesn't work at all
Please advise
Duncan
My instinct is that Duncan was right to ask a new question if the subject is different.
However, MWGainesJR, was right to ask for a question that was apparently answered to be closed.
Brad (byundt) is right by design.
My instinct is that Duncan was right to ask a new question if the subject is different.
However, MWGainesJR, was right to ask for a question that was apparently answered to be closed.
Brad (byundt) is right by design.
My instinct is that Duncan was right to ask a new question if the subject is different.
However, MWGainesJR, was right to ask for a question that was apparently answered to be closed.
Brad (byundt) is right by design.
My instinct is that Duncan was right to ask a new question if the subject is different.
However, MWGainesJR, was right to ask for a question that was apparently answered to be closed.
Brad (byundt) is right by design.
My instinct is that Duncan was right to ask a new question if the subject is different.
However, MWGainesJR, was right to ask for a question that was apparently answered to be closed.
Brad (byundt) is right by design.
My instinct is that Duncan was right to ask a new question if the subject is different.
However, MWGainesJR, was right to ask for a question that was apparently answered to be closed.
Brad (byundt) is right by design.
My instinct is that Duncan was right to ask a new question if the subject is different.
However, MWGainesJR, was right to ask for a question that was apparently answered to be closed.
Brad (byundt) is right by design.