Minimise XL from vb app?

[kev777]

I am deisgning a VB app that will open and close different XL spreadsheets and copy and paste data between them. I have copied the macros into the app which run fine after defining the object etc. but I cannot seem to minimise one of the sheets in the taskbar - keep geeting errors! Although if a sheet is minimised I can open it using the activate command from the Excel Macro! Any ideas?

Thanks,

Kev.

 

[JustinEzequiel]

Dim oXL As Excel.Application

Set oXL = GetObject(, "Excel.Application&quot

With oXL
.WindowState = xlMinimized
End With