Hi I'm using a macro that has function:
(My problem is, when I using Excel 2013. When excel is 2010 everything is OK)
1) On open, my .xlsm file, open external workbook, and update in background (Workbook.Visible = False)
excel 2013 open it behind of Active Worksheet (I can preview this file for several second) and leave (not close) blank excel instance.
2) when click button, assigned macro select Sheet "Search" (this sheet is only for "GUI purpose only" with text in it "Searching") and on exit macro, back to previous Sheet.
My macro:
Is there any chance to "repair" this?
Sorry for my bad english
(My problem is, when I using Excel 2013. When excel is 2010 everything is OK)
1) On open, my .xlsm file, open external workbook, and update in background (Workbook.Visible = False)
excel 2013 open it behind of Active Worksheet (I can preview this file for several second) and leave (not close) blank excel instance.
2) when click button, assigned macro select Sheet "Search" (this sheet is only for "GUI purpose only" with text in it "Searching") and on exit macro, back to previous Sheet.
My macro:
Code:
Sub My_Macro()
Sheets("Search").Activate ' Have the same problem when I used .Select function
Application.ScreenUpdating = False
Dim OrginalFileName As String
Dim xlApp As New Excel.Application
xlApp.Visible = False
OrginalFileName = ActiveWorkbook.Name
xlApp.Workbooks.Open Filename:="\\LOCATION\TO\FILE\FILE.XLSX"
Workbooks(OrginalFileName).Activate
......
....'some actions
..
xlApp.Workbooks("FILE.XLSX").Close SaveChanges:=False
xlApp.Quit
Set xlApp = Nothing
Application.ScreenUpdating = True
Sheets("MENU_1").Activate
End Sub
Is there any chance to "repair" this?
Sorry for my bad english