Excel Worksheet positioning

[flynbye]

I know that this is probably not difficult since I have found some reference to the Excel .move method but I'm having problems with positioning a newly created worksheet. Anyone have a quick example of how to move a worksheet available?

Thanks!


I always makes things much harder than they should be... that way later I can slap myself in the forhead after spending hours and hours on two lines of code and say to myself "DUH!"

 

[Ruffnekk]

Do you want to move it to another file or order the tabs differently in the same file?

Regards, Ruffnekk
---
Basic Instructions Before Leaving Earth (B.I.B.L.E.)

 

[djj55]

If you know the worksheet tab to insert it by you can make that tab active before the insert.

Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
oXL = CreateObject("Excel.Application")
oXL.Visible = True
oWB = oXL.Workbooks.Open("Temp.xls")
oSheet = oWB.Worksheets("My Tab")
oSheet.Activesheet
' move here

I hope this helps.
djj