Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Import File Data
Hi,
In a folder I have 10 excel files and I want to copy sheet2 data of all the exel file from the folder. Copied data will be pasted in a book.xlsx. Is it possible ? Eg, Folder called ABC and in that 10 excel files 001.xlsx, 002.xlsx........ Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Import File Data
Hi,
You can use this add-in if you want it easy http://www.rondebruin.nl/merge.htm Or see the code links on that page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... Hi, In a folder I have 10 excel files and I want to copy sheet2 data of all the exel file from the folder. Copied data will be pasted in a book.xlsx. Is it possible ? Eg, Folder called ABC and in that 10 excel files 001.xlsx, 002.xlsx........ Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Import File Data
This is just a demo. I have three files in a folder called "test". I open
the files sequentially and copy sheet2 of each file to the original sheet and save the original as book.xls. Change the extension to match your needs: Sub sheeet2() Dim s(10) As String, wb As Workbook Dim wbt As Workbook s(0) = "C:\test\alpha.xls" s(1) = "C:\test\beta.xls" s(2) = "C:\test\gamma.xls" Set wb = ActiveWorkbook For i = 0 To 2 Workbooks.Open Filename:=s(i) Set wbt = ActiveWorkbook Sheets("Sheet2").Copy Befo=wb.Sheets(1) wbt.Close wb.Activate Next ActiveWorkbook.SaveAs Filename:="C:\test\book.xls" End Sub -- Gary''s Student - gsnu2007L " wrote: Hi, In a folder I have 10 excel files and I want to copy sheet2 data of all the exel file from the folder. Copied data will be pasted in a book.xlsx. Is it possible ? Eg, Folder called ABC and in that 10 excel files 001.xlsx, 002.xlsx........ Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Import File Data
Thanks ron,
that's really nice one. I am not suppose to use add ins in office, If u provide code that will be helpful. On Mar 15, 4:17*pm, "Ron de Bruin" wrote: Hi, You can use this add-in if you want it easyhttp://www.rondebruin.nl/merge..htm Or see the code links on that page -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm wrote in ... Hi, In a folder I have 10 excel files and I want to copy sheet2 data of all the exel file from the folder. Copied data will be pasted in a book.xlsx. Is it possible ? Eg, Folder called ABC and in that 10 excel files 001.xlsx, 002.xlsx........ Thanks in advance |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Import File Data
See the "More Information" part of the page for the code links
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... Thanks ron, that's really nice one. I am not suppose to use add ins in office, If u provide code that will be helpful. On Mar 15, 4:17 pm, "Ron de Bruin" wrote: Hi, You can use this add-in if you want it easyhttp://www.rondebruin.nl/merge.htm Or see the code links on that page -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm wrote in ... Hi, In a folder I have 10 excel files and I want to copy sheet2 data of all the exel file from the folder. Copied data will be pasted in a book.xlsx. Is it possible ? Eg, Folder called ABC and in that 10 excel files 001.xlsx, 002.xlsx........ Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data from zip file through Internet | Excel Discussion (Misc queries) | |||
How to import data from a zipped file through Internet? | Excel Discussion (Misc queries) | |||
USING DATA FROM AN EXCEL FILE TO IMPORT INTO ANOTHER | Excel Worksheet Functions | |||
import multiline data from text file | Excel Discussion (Misc queries) | |||
import data from a text file | Excel Discussion (Misc queries) |