I myself could figure out a round about way to solve this problem as follows:-
A dummy excel file in the VB6.File application path was created. Before opening
Book2, that dummy file is forcefully opened/closed to trigger the security
warning box to appear on the screen, out front. Code used in VB6 is:-
Dim NConnect As FileDialog
Set NConnect = Application.FileDialog(msoFileDialogFolderPicker)
Set xlApp = New Excel.Application 'This file is opened only to force the vb to make the security warning box visible in the screen.
xlApp.Visible = True
Set wb = xlApp.Workbooks.Open(App.Path & "\dummy.xlsx")
wb.Application.DisplayAlerts = False
wb.NewWindow.Visible = True
Set xlApp = Nothing
Set wb = Nothing
Thank you for the quick response/solutions offered. I am interested in alternate
solutions to this problem and also any thoughts on my workaround.