Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default macro to merge workbooks

I need a way to merge up to 15 worksheets into one workbook. Can this be
done on a time schedule? Say everyday at midnight go out and get all 15
worksheets and copy them to 1 workbook. Is a macro the best approach or can
this be done through scripting?

thanks for input
Mike
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
Merge workbooks Bonnie Excel Discussion (Misc queries) 1 October 29th 07 11:50 PM
Merge Workbooks clara Excel Discussion (Misc queries) 1 April 10th 07 11:26 AM
merge workbooks FYF Excel Worksheet Functions 2 December 13th 06 06:50 PM
Macro to merge open workbooks Barry McConnell Excel Discussion (Misc queries) 1 August 23rd 06 05:09 PM
merge workbooks mg_sv_r Excel Worksheet Functions 1 June 14th 06 05:16 PM


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