Trying to get this small vba code to work the right way, but cant figure it out

[zone709]

As you may see its probably not the best way efficient, but it works almost the way I want it to except. At the end of macro I need it to leave me on workbook

Workbooks("FIle Zed Upload For Time Macro 2.xlsm").Activate

Which for some reason it doesn't now. If I play it slow motion then it does. So I'm confused on where the issue is.

Sub MoveCopy()
    Sheets("Name Correction").Copy Before:=Workbooks( _
    "FIle Zed Upload For Time Macro 2.xlsm").Sheets(1)
    Windows("FIle Zed Upload For Time Macro 2.xlsm").Activate
    Sheets("Name Correction").Move After:=Sheets(4)
    Workbooks("FIle Zed Upload For Time Macro 2.xlsm").Activate
End Sub

 

[JLGWhiz]

Hi so I'm back at it all day right. So it looks like the "Time" book is not the active sheet at that moment of code. Its the one I want to be active, but for some reason it wont view it on my screen. So I made the "Time" Active and then made the one I want active and it works. Look at code now for whatever reason this is I have no idea.

Sub MoveCopy()
    Sheets("Name Correction").Copy Before:=Workbooks( _
    "File Zed Upload For Time Macro 2.xlsm").Sheets(1)
    Sheets("Name Correction").Move After:=Sheets(4)
    Sheets(1).Activate
    Windows("Time").Activate     ' I have to activate
    Windows("FIle Zed Upload For Time Macro 2.xlsm").Activate  'Then activate this and then it shows this book in view as active' Not a clue why
End Sub

It sounds to me like your code resides in the "Time" workbook and not in the "File Zed..." workbook as originally stated. In any event, to activate a sheet when more than one workbook is open, you must first activate the workbook, then the sheet.

Workbooks("Time").Activate
Sheets("Sheet1").Activate

 

[zone709]

​Hi thanks for the reply. So this option doesn't work either.

Workbooks("Time").Activate
Sheets("Sheet1").Activate

Plus vba code is only in workbook FIle Zed Upload For Time Macro 2.xlsm. There is nothing in the Time one

Also I am thinking today since maybe the tab name "Name Correction" is getting moved and copy to this other sheet is confusing the code to believe its not actually active.

 

[JLGWhiz]

​Hi thanks for the reply. So this option doesn't work either.

Workbooks("Time").Activate
Sheets("Sheet1").Activate

Plus vba code is only in workbook FIle Zed Upload For Time Macro 2.xlsm. There is nothing in the Time one

Also I am thinking today since maybe the tab name "Name Correction" is getting moved and copy to this other sheet is confusing the code to believe its not actually active.

That was only an example to illustrate the sequence needed to activate a sheet in a workbook. The workbook has to be made active first, then the sheet. That is why I stay away from the Activate and Select syntaxes as much as possible. Direct coding is much better than the syntax used by the macro recorder.
Regards, JLG

 

[zone709]

That was only an example to illustrate the sequence needed to activate a sheet in a workbook. The workbook has to be made active first, then the sheet. That is why I stay away from the Activate and Select syntaxes as much as possible. Direct coding is much better than the syntax used by the macro recorder.
Regards, JLG

I know i agree. The only way for now that i got it to work is doing this. After it opens workbook it thinks even if you activate the other book that the active sheet is the wrong sheet. i don't know