save the file in .xlsm or .xlsb format to keep the macros
On Sun, Dec 15, 2013 at 10:45 PM, Bé Trần Văn wrote:
> You refer to the Code in File "Merge list of files".
>
> First open the File "Merge list of files", on sheet "Gop_File"
>
> Press Button "Merge list of files" and follow the instructi
Hi !
I have two Workbooks
1. Main (where I have a button and I intent to write code and paste the
data)
2. Data (where I have data to be copied)
My code so far
Sub copy()
Dim wbData As Workbook
Dim wbMain As Workbook
Set wbData = Workbooks.Open("path")
Set wbMain = Workbooks.Open("path")