VBA Coding Opening Excel 1

[DanSc0tt]

Hi,

Have the following code to open excel


Dim objXLApp As Object
Dim objXLBook As Object


Set objXLApp = CreateObject("Excel.Application")
objXLApp.Workbooks.Add
Set objXLBook = objXLApp.ActiveWorkbook

The code does not appear to work. However when I go and open Excel manually it opens to workbook 16 - it seems like it is opening workbooks in the background somewhere, but not giving me sight of them???

Any help would be great!

Thanks

Dan

 

[Remou]

Hi
objXLApp.Visible = True