This opens a new instance of excel. If someone runs your "solution", wouldnt that meant that he has excel already open? Or do you mean that he has another workbook open?
Dim xlApp As Object Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True xlApp.Workbooks.Add
If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
I think that is going in the direction I want to go. What I need to happen is when a user already has an excel workbook open and they double click on my excel workbook solution, my workbook will open in a new instance of excel because my workbook solution makes the excel workbook invisible and runs with user forms. Thank you for your help. If you have an idea for me I would appreciate the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks