Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default copy several files into one file

Hello
I have several files with different names. All of them have, one sheet with
the same structure
I need to copy these sheets into a new file, one after the other.
Is there a way to automate this task?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default copy several files into one file

Hi Raul

See
http://www.rondebruin.nl/fso.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Raul Sousa" wrote in message ...
Hello
I have several files with different names. All of them have, one sheet with
the same structure
I need to copy these sheets into a new file, one after the other.
Is there a way to automate this task?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search files and copy with destination on file ajtessy Excel Discussion (Misc queries) 0 March 9th 10 01:23 AM
Copy worsheet from different files in to one file Boss Excel Programming 1 April 14th 08 11:42 AM
use macros to copy and paste from 1 file to several files Joy Excel Worksheet Functions 0 March 5th 08 07:08 AM
Copy worsheet from different files in to one file Boss Excel Programming 3 February 11th 08 01:06 PM
Copy File Formulas between Files w/o the link PJ in CO Excel Worksheet Functions 3 December 12th 07 05:50 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"