Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default merging files

there is a folder containing 400 excel files which are on same pattern. I
want to merge all files in a single new excel file.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,123
Default merging files

Hi Maaz

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

Or one of the other examples on my site


--

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


"Maaz" wrote in message ...
there is a folder containing 400 excel files which are on same pattern. I
want to merge all files in a single new excel file.

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default merging files

i am new user i didnt know about amcros would please tell me about macros
from start

"Ron de Bruin" wrote:

Hi Maaz

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

Or one of the other examples on my site


--

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


"Maaz" wrote in message ...
there is a folder containing 400 excel files which are on same pattern. I
want to merge all files in a single new excel file.


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,123
Default merging files

Start here

See David McRitchie's site if you just started with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm

And post back if you need more help



--

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


"Maaz" wrote in message ...
i am new user i didnt know about amcros would please tell me about macros
from start

"Ron de Bruin" wrote:

Hi Maaz

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

Or one of the other examples on my site


--

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


"Maaz" wrote in message ...
there is a folder containing 400 excel files which are on same pattern. I
want to merge all files in a single new excel file.


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
merging zip files! via135 Excel Discussion (Misc queries) 2 November 19th 06 05:32 PM
merging two files mcap Excel Discussion (Misc queries) 3 April 9th 06 07:28 PM
merging multiple files ILXCEL Excel Discussion (Misc queries) 1 March 27th 06 06:16 PM
Merging Different excel files into one Neill Excel Discussion (Misc queries) 0 October 27th 05 09:15 PM
Merging two different files justinfisher Excel Discussion (Misc queries) 0 January 21st 05 08:53 PM


All times are GMT +1. The time now is 10:14 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"