Hi,
My problem is that i want to open my file in a new excel application/window. The following is the code i am using:
Sub ExcelInstances()
Dim xlApp1 As Object
Set xlApp1 = CreateObject("Excel.Application")
xlApp1.Visible = True
xlApp1.Workbooks.Open filename:="U:\Disable control wip\test\test_123.xls"
End Sub
When i run this code in VBA it can work. But when i open my file in my folder, i this code dont seems to run. What code can i use if i want to open the file in a new window.
Bear