Need help on inseting another worksheet

[eddie_leo84]

What i actually need is to insert an worksheet in the same file that i had opened. That mean i had already open an excel file and i wish to insert a new excel sheet on the excel file. How can i do that.

I had a method which it does to open a new new excel worksheet. Meaning the one i open i is but it open one more empty excel program. This isn't what i wanted. Can anyone help?

The coding are as below:

Public Function addNewWorkSheet() As Boolean
'To add new worksheets inside Excel
xlSheet = xlApp.Workbooks.Add.Worksheets()
End Function

[eddie_leo84]

Problem slove thanks alot for those who intented to help.

[Webtest]

Eddie ...

Here are a couple of hints for you.

When you post code, you should be sure to Format it. To do that, after you enter the code, highlight the stuff you want to show in code, and then click the "#" or the "VBCode" icon in the tool bar. You can also manually type the code tags. At the beginning, type code enclosed in square brackets [] and at the end type /code enclosed in square brackets [].

Once your question is resolved, please open your first post in the thread, and click the "Edit" icon at the bottom of the post. You can add [RESOLVED] to the Title, and please select the Green Checkmark item from the "Post Icons" list right below the post text edit box, and then save changes.

I hope this helps ...