Asked by duncanb7
at 2024-08-05 10:53:03
Point:250 Replies:7 POST_ID:828363USER_ID:11059
Topic:
Microsoft Excel Spreadsheet Software;Visual Basic Programming;Miscellaneous Programming
Question-1
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
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
