Re: $$Excel-Macros$$ copying data from another workbook

2013-12-15 Thread ashish koul
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

$$Excel-Macros$$ copying data from another workbook

2013-12-14 Thread Our Ned
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")