VBA code to create separate Excel instance and hide application

Hi All,

I'm looking for a way to open my workbook in a separate instance of Excel and then hide the application and show only a userform called Client_Information_UF.

After searching around I found this bit of code to create a separate instance of Excel, but if I change xlApp.Visible = True to xlApp.Visible = False, the application and workbook still shows behind the userform when opening. Not sure why, i thought the False statement would hide the application?

Private Sub Workbook_Open()

Dim xlApp As Excel.Application
Set xlApp = New Excel.Application
xlApp.Visible = True
Set xlApp = Nothing
Client_Information_UF.Show

End Sub


I need the application of this particular instance of Excel to hide only. If i was to use for e.g. a shared instance of Excel and use code like Application.Visible = False somewhere in my Sub, then it hides any other workbooks that the user may have open when I open this workbook.

Hope my question is clear and forgive me if its a really obvious solution. I'm really new to VB.

Thanks in advance

Patrick

Thanks for the speedy reply Rory. I had this bit of code in as well but all it did was create a blank workbook behind my userform, so i took it out.

xlApp.Workbooks.Add

The reason i want to hide one application and keep another open is because my userform is an insurance quoting platform, and users quoting on that will often be getting the data from another Excel workbook that has been giving to them.
So i'd like them to be able to open their workbook as normal, but when opening mine, only see the quoting platform as a userform.

My apologies. Noted on the cross posting...

What code would I use to do as you suggested?

But I'm not the one who is going to use the quoting userform. Its being rolled out to other users. They wont know to do that hence why i want code to do this automatically when the workbook is opened.
I need just the userform to display when opening my workbook, but not not to close any other workbooks that the user may have open, or open.

Ok but then the application will still show in the background just without a workbook? I dont want the application to be visible at all behind my userform.