Hi, I'm creating an Excel application and adding a new worksheet to it in a VB.NET windows application. The problem is, I want to be able to print the worksheet or save it. When I create the instance of the Excel application, the normal (File, Edit, View...etc) menu is not there at the top of the window. How can I get this to appear ? I've tried something like this:
mAppExcel = New Excel.Application
mWrkExcel = mAppExcel.Workbooks.Add
mWrkExcel.Application.WindowState = Excel.XlWindowState.xlNormal
'mAppExcel.CommandBars("Worksheet Menu Bar").Enabled = True
From what I've read, the CommandBars statement should enable this menu, but it doesn't. What am I missing?
Thanks!