Hello Mayank, You can save an Excel Workspace that will load all your related spreadsheets together.
Ø To create a Workspace: 1. Open all your spreadsheets 2. Arrange the windows as you like (the arrangement will be saved, too) 3. Save the Workspace: a. in Excel 2007/2010, Go to RIBBON>VIEW>Window>Save Workspace b. in Excel 2003 and prior, go to FILE>Save Workspace Ø To open your files together in the future, go to FILE>Open and select your Workspace file. For a little more info, see: · http://office.microsoft.com/en-us/excel-help/save-workbooks-in-an-arranged-w orkspace-HP010250051.aspx · http://office.microsoft.com/en-us/excel-help/save-workbooks-in-an-arranged-w orkspace-HP005202374.aspx?CTT=1 · http://www.fmsinc.com/free/NewTips/Office/excel.asp · http://www.ozgrid.com/Excel/save-as-workspace.htm Asa -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mayank Sent: Friday, February 10, 2012 12:46 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Load Excel Files Team, I have master file having 10 sheets. 1st sheet having summarize data (populated using formulas) of other 9 sheets and these 9 sheets contains data from 6 different files (3 files having two tabs each) and this is daily process. Need VBA code through which I can load those files with single click so that I can get rid of copy and paste every time. I can have master file and other 9 files in same folder. Note: need to have entire sheet copy and paste in respective sheet in master file. Thanks! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to <mailto:excel-macros@googlegroups.com> excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
