'Worksheets copy not works

I have a spreadsheet named "BalançoGeral.xlsm" that opens another spreasheet named "ControleFinanceiroGeral.xlsm" and I would like to copy the sheet (4) of the opened spreadsheet after the first sheet from "BalançoGeral.xlsm". The following copy command does not work and the sequence does not issue any error message. What is the problem?

Vitor

Workbooks.Open Filename:="ControleFinanceiroGeral.xlsm", ReadOnly:=True Workbooks("ControleFinanceiroGeral.xlsm").Worksheets(4).Copy After:=ThisWorkbook.Worksheets(1)

excel vba copy

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Worksheets copy not works

Sources

Related Questions